Question: Question 8 3 pts For the following SQL query, which statement about measures and dimension attributes is true? SELECT store.store_address, SUM(sales.quantity) As quantity_sold FROM sales

Question 8 3 pts For the following SQL query, which statement about measures and dimension attributes is true? SELECT store.store_address, SUM(sales.quantity) As quantity_sold FROM sales INNER JOIN product ON sales.product_id = product.product_id INNER JOIN time ON sales.time_id = time.time_id INNER JOIN store ON sales.store_id = store.store_id WHERE time. action_year = 2016 AND store.city = 'Berlin' AND product.product_type = 'phone' GROUP BY store.store_id, store.store_address Osales.quantity and quantity_sold are measures and store.city is a dimension attribute. O time.action_year and sales. quantity are measure attributes and store.city is a dimension attribute. store.city is a non-additive measure and product.product_type is a dimension attribute. O sales.quantity is a measure attribute and store.city is a dimension attribute. O all of the above are true O none of the above are true
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
