Please write queries based on the following requirements using Premier Database.
ID: 3935411 • Letter: P
Question
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
Explanation / Answer
10. SELECT transaction_id
from Database
Where firstname LIKE 'B%' OR purchased="no";
Select firstname,lastname
ORDER BY lastname ASC