Basic SQL question about specifying a group of years in a table. Working on a database and it is wanting me to list the author, title, publication date and retail price. I have that part down but its also ask to output all titles that start with "D" and were published in the 1970s.
I have the first part down: (this is how we are taught btw)
SELECT fauthorID, fTitle, fPubYear, fReatailPrice FROM tbooks WHERE fTitle Like 'D%' AND fPubYear Like '197_'