[Solved]Create 5 Queries Based Database Explain Information One Obtain Running Queries Query Must Q37275786
Create 5 queries based on your database and explain whatinformation one can obtain from running each of the queries. Eachquery must contain at least one of the following:
- Some conditions and sorting
- Multiple fields from multiple tables
- Grouping
Step 4 INSERT INTO Customer (FirstName, LastName, Street, City, State) VALUES ( “Bob”, “Doe”, “Naija Road”, “Park View”, “PA”), ( “Tom”, “Ford”, “Dell Way”, “Third Street”, “CA”), (“Charlie”, “Milk”, “Broad Road”, “Long Street”, “NY”), (“Don”, “Cool”, “Car Way”, “Lion View”, “NJ”), (“Steve”, “Rich”, “Long Avenue”, “Mountain View”, “NJ”); INSET INTO Orders (ReplD, VINID, CustomerID, SalesPrice, Finance, PaymentType. PurchaseDate) VALUES (l,1, 1, 32080, True, “Credit Card”, “2019-01-01”), 2, 2,2, 15700, False, “Credit Card”, “2019-12-28”), (3, 3,3, 12560, True, “Cash”, “2019-03-11”), 4, 4, 4, 19500, False, “Cash”, “2019-11-23”), C5, 5, 5, 34560, True, “Credit Card”, “2019-09-21”); INSERT INTO SalesRep, (FirstName, LastName, Street, City, State, CommissionRate) VALUES (“Dan”, “Pet”, “Av. Paulista”, “São Paulo”, “NJ”,20), (Alex”, “Niel”, “Snow Road”, “Rio de Janeiro”, “PA”, 11.5), (“Kara”, “Martins”, “Oladeji Street”, “Brasília”, “DF”, 15.8), (“Eduardo”, “Almeida”, “Fast Road”, “West”, “NJ”,14), (“Roberto”, “Rocha”, “Pender Street”, “Vancouver”, “NY”, 18); INSERT INTO Cars (Model.Year, Make, MSRP, Color, Type) VALUES (WA8″, “2019”, “Audi”, 22000, “black”, “convertible”), (Q0″, “2017”, “Infiniti “, 40000, “red”, “sports”), (Fusion”, “2014”, “Ford”, 16000, “grey”, “sedan”), (“Q70”, “2018”,”Infiniti”, 32000, “blue”, “sports”), (Camry”, “2016”, “Toyota”, 15000, “black”, “sedan”); Show transcribed image text Step 4 INSERT INTO Customer (FirstName, LastName, Street, City, State) VALUES ( “Bob”, “Doe”, “Naija Road”, “Park View”, “PA”), ( “Tom”, “Ford”, “Dell Way”, “Third Street”, “CA”), (“Charlie”, “Milk”, “Broad Road”, “Long Street”, “NY”), (“Don”, “Cool”, “Car Way”, “Lion View”, “NJ”), (“Steve”, “Rich”, “Long Avenue”, “Mountain View”, “NJ”); INSET INTO Orders (ReplD, VINID, CustomerID, SalesPrice, Finance, PaymentType. PurchaseDate) VALUES (l,1, 1, 32080, True, “Credit Card”, “2019-01-01”), 2, 2,2, 15700, False, “Credit Card”, “2019-12-28”), (3, 3,3, 12560, True, “Cash”, “2019-03-11”), 4, 4, 4, 19500, False, “Cash”, “2019-11-23”), C5, 5, 5, 34560, True, “Credit Card”, “2019-09-21”); INSERT INTO SalesRep, (FirstName, LastName, Street, City, State, CommissionRate) VALUES (“Dan”, “Pet”, “Av. Paulista”, “São Paulo”, “NJ”,20), (Alex”, “Niel”, “Snow Road”, “Rio de Janeiro”, “PA”, 11.5), (“Kara”, “Martins”, “Oladeji Street”, “Brasília”, “DF”, 15.8), (“Eduardo”, “Almeida”, “Fast Road”, “West”, “NJ”,14), (“Roberto”, “Rocha”, “Pender Street”, “Vancouver”, “NY”, 18); INSERT INTO Cars (Model.Year, Make, MSRP, Color, Type) VALUES (WA8″, “2019”, “Audi”, 22000, “black”, “convertible”), (Q0″, “2017”, “Infiniti “, 40000, “red”, “sports”), (Fusion”, “2014”, “Ford”, 16000, “grey”, “sedan”), (“Q70”, “2018”,”Infiniti”, 32000, “blue”, “sports”), (Camry”, “2016”, “Toyota”, 15000, “black”, “sedan”);
Expert Answer
Answer to Create 5 queries based on your database and explain what information one can obtain from running each of the queries. Ea… . . .
OR
