SQL

1. Write a query that returns the cost of parts used for building an SD70Ace model
2. Select the average order size (average number of units) per customer for each model
3. Return number of orders for customer outside the USA
4. Write an SQL to add a new order for 25 units of SD60 bought by UP
5. Write an SQL operation that deletes all order made prior to 2000

Part Inventory id Cost Supplier Location Name Traction motor 200 Melco Japan Alternator HVAC Warehouse id quantit A1 A2 B1 100 250 300 400 kato 300 Melco Japan USA Customer Model Location Model SD70Ace160 SD70M SD60 id Quantit CN UP BT Name anada National nion Pacific anada USA Bombardier Transport Sweden Orders order id C id CN UP Model nbUnit Year SD70Ace50 SD70Ace 2018 2018 60