I am currently working on some select queries and am getting the error
FROM keyword not found where expected
SELECT Title, PubID AS 'Publisher ID', PubDate AS 'Publish Date'
FROM Books WHERE PubID = 4 OR PubDate > '01-Jan-01'
ORDER BY PubID ASC;
SELECT Title, (((Retail-Cost)/Cost) * 100) AS 'Markup %'
(retail - cost / cost * 100 is the goal)
Single quotes are used to surround string literals. Double quotes are used to surround identifiers. Column aliases are identifiers so you'd want to use double quotes
SELECT Title, PubID AS "Publisher ID", PubDate AS "Publish Date" FROM Books WHERE PubID = 4 OR PubDate > '01-Jan-01' ORDER BY PubID ASC;