Answered step by step
Verified Expert Solution
Link Copied!

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?
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Making Databases Work The Pragmatic Wisdom Of Michael Stonebraker

Authors: Michael L. Brodie

1st Edition

1947487167, 978-1947487161

More Books

Students also viewed these Databases questions