SQL аnd OLAP (Pаrt 3) — Queries Instructiоns An аutоmоbile company wishes to maintain data about orders and analyze sales of its cars. The Customers can order any serial of cars from this company with any dealer. The fact table for such a database is given as: Sales(serialNo, date, dealer, price, quant) The attributes are defined as: serialNo, representing the automobile sold. date, representing the day of the sale. dealer, representing the dealer of this sale. quant, representing the number of cars ordered by this customer. price, representing the total cost of each sale. The dimension tables are given as following: Autos(serialNo, model, color) Dealers(dealer, city, state, phone) Days(date, week, month, year) Attribute serialNo, dealer and date in the fact table Sales are foreign key, referencing the attributes in corresponding dimension table Autos, Dealers and Days. With the fact table and dimension tables provided above, we produce the data cube as below: CREATE MATERIALIZED VIEW SalesCube AS SELECT model, color, date, dealer, SUM(quant) FROM Sales NATURAL JOIN Autos GROUPBY model, color, date, dealer WITH CUBE; Using the data cube created above, find, for each color, the total number of cars ordered from each dealer in Gainesville. How to complete this question: Write your response in the text box below.
Chооse оne: Compаre two wаys of losing weight—one heаlthy and one dangerous Compare two homeschooling and attending a public school