Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can i have answer of this question please? www.22 Based on the tables given construct a SQL statement for the following questions 100 Table 1
can i have answer of this question please?
www.22 Based on the tables given construct a SQL statement for the following questions 100 Table 1 Customer Customer Curstomeriame Address Phone No ABOO Hamilton bin No 9, Lintang Sungai 100, 03-12919136 Ride Tmn Klang Utama, Selangor AB002 Tan Guat Mool No 38, 4, Jalan Meri, Setia 03-32224111 Alam, Shah Alam, Selangor ABOOS Nurin Sofia No 1. Taman Klang Perdana 03-94211328 Ahmad Klang, Selangor Table 2 Groceries Product Categories Product Price (RM) 000 Beverages Sprite 20 004 Fresh Potato 10 001 Meat Salmon 35 009 Cookies Oreo 9 010 Dary Mi 15 011 Alery Bread 014 MAR Table Order DateOrder Date Delivery Products Orderio Quantity 1100 1210 1115 1422 1552 1652 1766 01/02/2022 05/02/2022 05/02/2012 10/02/2012 20/02/20222/09/2022 01/092032 17/01/2012 01/01/2022 29/01/2022 H/04/2022 25/04/2003 01/01/2022 17/05/2012 S/OS/2022 17/05/2022 002 000 309 DOP 002 OIB Di 014 5 2 1 7 10 5 1 S Totalprice IRMI 100 TO 9 140 200 25 15 40 1899 a) Insert a new record in the "Groceries" table. INSERT (015, 'Snacks', 'Twisties 10) Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started