Question: What is the SQL query? # Collation Attributes Default Comments Null No Extra AUTO_INCREMENT 1 None 2 No None OOOO 3 Name Type product_id int(11)



What is the SQL query?
# Collation Attributes Default Comments Null No Extra AUTO_INCREMENT 1 None 2 No None OOOO 3 Name Type product_id int(11) product_name varchar(100) product_description varchar(500) product_img varchar(100) product_stock int(11) product_price decimal(18,2) utf8_general_ci utf8_general_ci utf8_general_ci Yes NULL 4 Yes NULL 5 Yes NULL 6 Yes NULL TAR # Collation Attributes Comments Null No Default None Extra AUTO_INCREMENT 1 2 Name Type order_id int(11) product_id int(11) user_id int(11) address_id int(11) No None 3 No None 4 No None -T- address_id users_id address_line_1 address_line_2 CA 1 1 79 Beach Rd Mouille Point 2 15 Knysna Central address_line_3 city Cape Town Knysna Rivonia Johannesburg Yellow Sands Tatooine Villa state_province zip Western Cape 8005 Western Cape 6571 Gauteng 2191 Tatooine 908709 2 Gray St Bentley Office Park Apartment 21 3 9 70 Wessel Road 4 14 2461 desert Road Edit : Copy Edit * Copy Edit + Copy Edit ** Copy Edit Copy Edit + Copy Edit + Copy Edit + Copy Edit Copy X Delete X Delete X Delete X Delete X Delete X Delete X Delete X Delete X Delete 5 10 59 Albert Embankment Lambeth UK SE1 7TP London Springfield 6 8 ORE 97001 742 Evergreen Terrace Queens Palace 7 14 Naboo Main Road Naboo City Naboo NAB 71992 OOOO 8 12 28201 E. Bonanza St. South Park CAL 28201 South Park City South Park City 9 12 635 Avenue de Los Mexicanos South Park CAL 28201 W TAHL AJ: Action Browse Structure Table addresses orders products 19 Search O Search Browse Structure Browse Structure Q Search users Browse Structure Q Search 4 tables Sum 2) Notice among the following three table: address, orders and product, there are a few KEYS can be used to combine information for joint analysis. Please use user(s)_id" and "product_id" as the key to inner join the following three tables into one single table: addresses, orders and products. Include the SQL code and screenshot. If you are interested, also try other types of joins (not to be marked)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
