Please write queries based on the following requirements usi

Please write queries based on the following requirements using Premier Database. Premier Database can be downloaded from Blackboard. For each question, you are required to submit 1) SQL query code and 2) a screen shot of your query results (if your results contains more than 15 records, you can submit a screen shot of the top 15 records).

10. List the transactions by members with first name starts with “B”, including members who have not purchased any items. Show the full name of each member in the ascending order on member’s last name.

database: https://onedrive.live.com/redir?resid=A1E5259BDD065B48!4478&authkey=!AH3fj0xU0Jv_Jyc&ithint=file%2caccdb

Solution

10. SELECT transaction_id

from Database

Where firstname LIKE \'B%\' OR purchased=\"no\";

Select firstname,lastname

ORDER BY lastname ASC