SQL Programming (Simply Answer all the question)

This schema is used for inventory management for an OEM Part Inventorv Name Cos Suppli Locatio p id Warehouse i quantit t er Traction Alternator 400 kato HVAC 1 A1 100 250 300 200 Melco Ja USA 300 Melco Ja 3 BI Customer Model id Name CN UP Union Pacific BT Bombardier Transport Sweden Location Model pi Quantity National USA SD70A 1 60 SD60 3 Orders order i C id Mode nbUnit Ye CN SD70Ace 50 UP SD70Ace 60 2018 2018 Total point 67 Hints: part p id is the primary key for part. Part relation includes the part information and their suppliers Inventory tables list the parts, their quantities and warehouse_id they are stored in. Both p id and warehouse id form the primary key The customer table stores the customer information and uses c_id as primary key The model table includes the Model name and the part it constitutes. It uses Model and p id as primary key Order includes all the order's information, what Model customer orders, how many units and which year they place the order in. IL. SQL Queries (total 39 points) 1. (3 points) Write an SQL query that returns the names of all the customers that bought either 'SD70Ace' or SD70 ACs' models. 7. (5 points) Return the gross sale of supplier 'Melco' 8. (3 points) Return number of orders for customer outside the USA