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.

using microsoft SQL server the tables in the 'Antiques' Database are below,

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!