COMPSCI 122A Study Guide - Final Guide: Data Science, Mysql, Adobe After Effects
8 Sep 2020
School
Department
Course
Professor
Document Summary
Last name: sun first name: bolun student id: 52332355: [10pts] for all customers who have placed at least 3 orders with a per-order total price greater than. Expected result row(s): 2: [7pts] sql query: Rank those products by this quantity from high to low and show only the top 12 products. Expected result row(s): 12: [7pts] sql query: Expected result row(s): 5: [7pts] sql query: Select distinct products. product_id, products. name, count(*) from products, orders, customers, orderitems where orders. customer_id = customers. user_id and orders. order_id = orderitems. order_id and products. product_id= orderitems. product_id group by products. product_id,products. name having count(*)>=(select count(*)*0. 05 from customers): [3pts] result, views [20 pts] The cto has formed a data science team to analyze the shopping activities of each customer who has shopped at jackson food store, and she has made you the head of that team. The view should provide access to a combination of the following information:
