SQL: Query Planning
Create a plan for each of the queries listed below. You’ll earnone point for each question plan.
You can use the query questions I use or another framework(including one you make up) but I’m looking for a plan that helpsclearly define what needs to happen in the query. Just restatingthe question won’t earn a point, and code will not be graded.
Which New Age computer books cost more than $15?
How many cookbooks has each publisher published?
How many computer and business books have been published inCalifornia?
Display the title, full author name, and amount of royalty anauthor is projected to earn (projected sales * price * royaltyshare).
Display all authors and the titles of any books they’vewritten.
Upload your plan as a Word file.