1 Show the employee ID number and name for only the first three employees (the ones with the three lowest ID numbers).
Hint: use TOP while sorting by ID number. Format all columns using CAST, CONVERT, and/or STRING, and rename the
columns using AS.’
2 For each row in the REPAIR_LINE_ITEM table, show the repair number, line number, and values of ExtendedPrice
and “Labor Charge” added together (rename this value to TotalCharge). Sort results in descending order by TotalCharge.
3 Show the name, street address, and city/state/ZIP code for all customers who live in Oregon. Combine
city, state, and ZIP code into a single line in this format:
“Portland, OR 97201”
…and rename this column City/State/ZIP (exactly this name! there is a way to do it).
4 For all STOVE_REPAIR records, show the repair number, stove number, repair description, and repair date.
Order the data chronologically by repair date (most recent first), and display the date in this
format: MM/DD/YYYY. Format the output to be readable (i.e. to fit neatly into a page)
5 For all INVOICE rows which have a TotalPrice value between $100 and $200 (inclusive), show the invoice number,
total price, and employee number. Order the output by invoice number. Format all three columns using STR;
display the cost as money (i.e. use two decimal places for cents, and put a dollar sign before it; e.g. $12.54).’
"96% of our customers have reported a 90% and above score. You might want to place an order with us."
