Question
A selection of the expected result set has been shown below for your convenience. Your output should match with this sample output. PAY SPECIAL ATTENTION
A selection of the expected result set has been shown below for your convenience. Your output should match with this sample output.
PAY SPECIAL ATTENTION TO COLUMN NAMES.
Create and execute a query that returns first 20 records with Vendors names, state and city sorted with respect to their states (within each state) [schema: ap]
Create and execute a query that returns Employees IDs and full names (as shown) and only for those employees who first name starts with the letter R. [schema: ex]
The query would return only 3 rows as shown here
Create and execute a query that returns the CD titles, their original unit price and then a discounted price (after 20% discount and rounded off to 2 decimal places only) and sort the results with respect to the discounted price. [schema: om]
The query would return 10 rows as shown here
\begin{tabular}{|lll} vendor_name & vendor_state & vendor_city \\ \hline Computer Library & AZ & Phoenix \\ AT\&T & AZ & Phoenix \\ Wells Fargo Bank & AZ & Phoenix \\ Yale Industrial Trucks Fresno & CA & Fresno \\ Costco & CA & Fresno \\ Jobtrak & CA & Los Angeles \\ California Chamber Of Commerce & CA & Sacramento \\ Towne Advertiser's Mailing Svcs & CA & Santa Ana \\ BFI Industries & CA & Fresno \\ Pacific Gas \& Electric & CA & San Francisco \\ Robbins Mobile Lock And Key & CA & Fresno \\ Bill Marvin Electric Inc & CA & Fresno \\ City Of Fresno & CA & Fresno \\ Golden Eagle Insurance Co & CA & San Diego \\ & C. & - \end{tabular} \begin{tabular}{|ll} \hline employee_id & EmployeeName \\ \hline 3 & Ralph, Simonian \\ 5 & Robert, Aaronsen \\ 8 & Rhea, O'Leary \end{tabular} \begin{tabular}{lcc} title & unit_price & afterdiscou \\ \hline Race Car Sounds & 13.00 & 10.40 \\ Rude Noises & 13.00 & 10.40 \\ No Rest For The Weary & 16.95 & 13.56 \\ No Fixed Address & 16.95 & 13.56 \\ Zone Out With Umami & 16.95 & 13.56 \\ Etcetera & 17.00 & 13.60 \\ On The Road With Burt Ruggles & 17.50 & 14.00 \\ Umami In Concert & 17.95 & 14.36 \\ More Songs About Structures and Comestibles & 17.95 & 14.36 \\ Burt Ruggles: An Intimate Portrait & 17.95 & 14.36 \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started