SCode MS3 B1 W6 PRI MS4 E11 Sname Panda Danoub LULU Danoub Tamimi Panda 29 30 Location Riyadh Abha Customer Cname Age Sex Address Saud 18 Hala 62 Fahad 45 Hessa 74 Noura Sultan M F M F F M Riyadh Riyadh Dammam Dammam 11 street 127 street 11 street Туре Clothes Chemist General Clothes Clothes Books

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
SCode
MS3
B1
W6
PR1
MS4
E11
Supermarket
SCode
MS3
B1
Sname
Panda
Danoub
LULU
Danoub
Tamimi
Panda
Cname
Saud
Hala
Fahad
Hessa
Noura
Sultan
W6
PR1
MS4
E11
Customer
Age Sex Address
18
M
62
F
45 M
74
29
30
Buy
CName
Saud
Halaa
Fahad
Hessa
Noura
Sultan
Location
Riyadh
Abha
Riyadh
Riyadh
Dammam
Dammam
F
F
M
11 street
127 street
11 street
Item
Coat
Scarf
Shoes
Socks
Perfume
Book
Type
Clothes
Chemist
General
Clothes
Clothes
Books
Cost
35.00
10.00
30.00
1.50
18.00
2.50
Transcribed Image Text:SCode MS3 B1 W6 PR1 MS4 E11 Supermarket SCode MS3 B1 Sname Panda Danoub LULU Danoub Tamimi Panda Cname Saud Hala Fahad Hessa Noura Sultan W6 PR1 MS4 E11 Customer Age Sex Address 18 M 62 F 45 M 74 29 30 Buy CName Saud Halaa Fahad Hessa Noura Sultan Location Riyadh Abha Riyadh Riyadh Dammam Dammam F F M 11 street 127 street 11 street Item Coat Scarf Shoes Socks Perfume Book Type Clothes Chemist General Clothes Clothes Books Cost 35.00 10.00 30.00 1.50 18.00 2.50
Translate the following into SQL queries:
INSERT THE VALUES TO THE
TABLES !!!
How many supermarkets are
located in Dammam or Abha?
Get locations of all supermarkets, get only
the locations having more than one
supermarket.
Transcribed Image Text:Translate the following into SQL queries: INSERT THE VALUES TO THE TABLES !!! How many supermarkets are located in Dammam or Abha? Get locations of all supermarkets, get only the locations having more than one supermarket.
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Features of HTML
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education