Question: using microsoft SQL server the tables in the 'Antiques' Database are below, detailing the employees of an antiques company, what they sell, and who they
using microsoft SQL server
the tables in the 'Antiques' Database are below, detailing the employees of an antiques company, what they sell, and who they sold it to.
Training Cost is found in the Training_Course table (bottom left)
QUESTION:
Write a query that displays the state and provides an average training cost for each state. Dont include employees with the last name Matsko. Limit the output to two decimal places and order the results by State.

CUSTOMER CustomerlD Last Name FirstN ame c State Hunt Holland Peterson Braxton Baum Miller ohnsorn Richardson Ben Stull Brotherson Duane om Scott Dana Conrad Cod Madd Stephanie San Antonio Great Falls Great Falls New York Portland Salem Dallas EMPLOYEE elD LastName FirstName Cit State Gender NY UT Male CA Male CA Male Male MT Female Bob Johnson Olsen Matsko Olsen Wendorf David Rich Beverl Curb Salt Lake San Diego San Diego Dallas Great Falls Salem Salem San Diego Di ego Katheline SALE EMPLOYEE TRAINING SalelD CustomerlD EmployeelDSale Date 6/16/2015 6/16/2015 6/16/2015 EmployeelD Trainl nlnglD Grade CompletlonDate Sate Total EmployeeCommission 1000 5/16/2015 5/16/2015 6/16/2015 5/20/2015 5/16/2015 SALE ITEM SalelDSaleltemID ProductiDItemPrice TRAINING COURSE TrainingID TrainingName TrainingDescription Learn about US Silver Learn abo ut Wond Coins Learn abo ut Customer Service Learn abo ut Pricing Antiques Training Cost Silver Eagles 101 World Coins ustomer Service 1400 Antique Pricin 900 PRODUCT ProductlD ProductName MetalType Qual itylD ProductCou VendorlD American Silver Eagle Silver United States 2Maple Le af Kookaburra Silver anada Austrialia
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
