SQL

1. Write a query that returns the parts and their quantities that are not in stock for building the order 1
2. Write a query that selects the models to be removed if parts in stock are less than 10% of it over all parts
3. Return the gross sale of supplier Melco
4. Write an SQL operation to increase parts price by 10% for US supplier and 15% for international suppliers
5. Update inventory increasing all part less than 100 by 20 parts in warehouse A1.

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 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