1. List GodaAloct and Description for Stock. 2. List CodeSteck and sales representative for description which started with letter C. 3. List sales representative and area for sales representative In Ampang area and Selayang

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
icon
Concept explainers
Question
аток
Code stock
Description
agent
Location
Keropok
Poh Hua
B011
Kepong
A001
Ikan Blis
Mimi
Ampang
B511
Coca-Cola
Azm
Selayang
CI Kering
Air Soya
D401
LIza
Puchong
A023
Khairul
Ampang
JUALAN
Sell Code
Code stock
Sell date
Buy_Price
Sel Price
Quantity
M33
AD01
18/04/02
O.80
1.30
35
M23
A023
1905/02
1.50
2.30
20
L02
B511
23/04/02
0.80
1.40
90
B014
13/02/02
0.60
1.20
3
L13
D401
02/02/02
0.75
0.90
50
Transcribed Image Text:аток Code stock Description agent Location Keropok Poh Hua B011 Kepong A001 Ikan Blis Mimi Ampang B511 Coca-Cola Azm Selayang CI Kering Air Soya D401 LIza Puchong A023 Khairul Ampang JUALAN Sell Code Code stock Sell date Buy_Price Sel Price Quantity M33 AD01 18/04/02 O.80 1.30 35 M23 A023 1905/02 1.50 2.30 20 L02 B511 23/04/02 0.80 1.40 90 B014 13/02/02 0.60 1.20 3 L13 D401 02/02/02 0.75 0.90 50
1. List Godaloct and Description for Stock.
2. List Godhaleck and sales representative for description which started with ietter C.
3. List sales representative and area for sales representative In Ampang area and Selayang
4. List description and location for goods sold by Bal Hu
5. List GodhalockRkaRA and sales representative which sels soya bean juice.
Transcribed Image Text:1. List Godaloct and Description for Stock. 2. List Godhaleck and sales representative for description which started with ietter C. 3. List sales representative and area for sales representative In Ampang area and Selayang 4. List description and location for goods sold by Bal Hu 5. List GodhalockRkaRA and sales representative which sels soya bean juice.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Query Syntax
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
  • SEE MORE 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