Let us consider the following sample database called “BikeStores”.

1) Create database tables.

6) Write SQL statement, which sorts the customers by the city in descending order and the sort the sorted result set by the first name in ascending order.

 

 

Transcribed Image Text:

Let us consider the following sample database called "BikeStores". Sales customers *customer_id first_name last_name phone email street city state zip_code orders *order_id customer_id order_status order_date required_date shipped_date store_id staff_id 1) Create database tables. + staffs *staff_id first name last_name email phone active store_id manager_id phone email street stores *store_id store_name city state zip_code order_items *order_id "item_id product_id quantity list price discount ++ Production categories *category_id category_name products *product_id product_name brand id category_id model year list price stocks store_id "product_id quantity brands brand id brand_name Let us consider the following sample database called "BikeStores". Sales customers *customer_id first_name last_name phone email street city state zip_code orders *order_id customer_id order_status order_date required_date shipped_date store_id staff_id 1) Create database tables. + staffs *staff_id first name last_name email phone active store_id manager_id phone email street stores *store_id store_name city state zip_code order_items *order_id "item_id product_id quantity list price discount ++ Production categories *category_id category_name products *product_id product_name brand id category_id model year list price stocks store_id "product_id quantity brands brand id brand_name