File Edit View Navigate Code Befactor Run Tools Git Window Help postgres@localhost [3] Database = -113333.sql postgres@localhost [3] + ©GA 8 = » R _ { • » @ < • • 540 * ? postgres@localhost 2 of 4 postgres@localhost [2] 2 of 5 postgres@localhost [3] 3 of 7 class 1 of 3 public ✓tables 6 > adreeses > > > > > I > sequences 6 Database Objects ✓ public customer_phones customers orders phone types products > access methods 7 > casts 229 > extensions 1 >languages 4 postgres 1 of 3 shoppingdb 0 of 3 No schemas selected Database Objects > access methods 2 Services >casts 229 > extensions 1 >languages 4 Server Objects Tx I ÷ {{ M + products name varchar(512) stock cost real real unit price real product_id integer postgres@localhost [3] ✓ console 3s 171 ms 113333.sql 44 ms product_id Powered by yFiles data1-postgres@localhost [3] customer_id orders customer id integer product_id integer quantity integer datetime timestamp order id bigint customers first name varchar(100) middle name varchar(100) last name varchar(100) birth date is active customer_id customer_id date boolean integer customer_id adreeses customer_id integer description varchar(256) postal code integer city varchar(100) adress_id integer 1 phone_types description varchar(100) phone_type_id integer K
File Edit View Navigate Code Befactor Run Tools Git Window Help postgres@localhost [3] Database = -113333.sql postgres@localhost [3] + ©GA 8 = » R _ { • » @ < • • 540 * ? postgres@localhost 2 of 4 postgres@localhost [2] 2 of 5 postgres@localhost [3] 3 of 7 class 1 of 3 public ✓tables 6 > adreeses > > > > > I > sequences 6 Database Objects ✓ public customer_phones customers orders phone types products > access methods 7 > casts 229 > extensions 1 >languages 4 postgres 1 of 3 shoppingdb 0 of 3 No schemas selected Database Objects > access methods 2 Services >casts 229 > extensions 1 >languages 4 Server Objects Tx I ÷ {{ M + products name varchar(512) stock cost real real unit price real product_id integer postgres@localhost [3] ✓ console 3s 171 ms 113333.sql 44 ms product_id Powered by yFiles data1-postgres@localhost [3] customer_id orders customer id integer product_id integer quantity integer datetime timestamp order id bigint customers first name varchar(100) middle name varchar(100) last name varchar(100) birth date is active customer_id customer_id date boolean integer customer_id adreeses customer_id integer description varchar(256) postal code integer city varchar(100) adress_id integer 1 phone_types description varchar(100) phone_type_id integer K
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
Related questions
Concept explainers
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
Question
Hi
i have to get the total orders from phone id
And average orders from the posta code
Can you write data base codes to get this information
![DG File Edit View Navigate Code Refactor Run Tools Git Window Help data1 - postgres@localhost [3]
postgres@localhost [3]
Database Explorer
Bookmarks
Database
+ 0 G
postgres@localhost 2 of 4
postgres@localhost [2] 2 of 5
postgres@localhost [3] 3 of 7
class 1 of 3
✓ public
✓ tables 6
>
>
>
>
>
> customer_phones
>
>
>
products
sequences 6
>
✓ Database Objects
>
>
✓ public
>
>
adreeses
customers
orders
extensions 1
languages 4
postgres 1 of 3
"
phone_types
shoppingdb 0 of 3
No schemas selected [...]
✓ Database Objects
Services
access methods 7
casts 229
✿
= » KE?
extensions 1
> languages 4
Server Objects
access methods 7
casts 229
Tx = = = A +
✓postgres@localhost [3]
console 3 s 171 ms
Sa 113333.sql 44 ms
Version Control
12°C
Kısmen güneşli
TODO
SO 113333.sql
1:1
postgres@localhost [3]
products
name varchar(512)
stock
cost
real
real
unit_price real
product_id integer
Powered by yFiles
product_id
自行L S*?
→ Problems ▸ Services
orders
customer_id integer
product_id integer
quantity integer
datetime timestamp
order_id bigint
customer_id
customers
first_name varchar(100)
middle_name varchar(100)
last_name varchar(100)
birth_date
is_active
customer_id
customer_id
date
boolean
integer
customer_id
adreeses
customer_id integer
description varchar(256)
postal_code integer
city varchar(100)
adress_id integer
▬▬
▬▬▬▬
> Output
K
1
phone_types
description varchar(100)
phone_type_id integer
phone_type_id
customer_phones
< 1 row ✓
O Search
customer_id
integer
phone_type_id integer
phone
char(15)
customer_phone_id integer
count(*): bigint
Ç
count =
Ⓡ
▼
Add Configuration...
CSV v
ENG
B
4) O
0
CPU 1%
GPU 15%
VRAM 0%
RAM 73%
FPS --
±F © ☀
11:00 ص
⠀
T.TT/T/-V
Structure Notifications
2](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F5271313a-5a1f-4d07-82a4-8e8f0bce0b42%2F7cf36328-a6f1-4410-8c8e-689a5a3c5559%2F9uxih_processed.png&w=3840&q=75)
Transcribed Image Text:DG File Edit View Navigate Code Refactor Run Tools Git Window Help data1 - postgres@localhost [3]
postgres@localhost [3]
Database Explorer
Bookmarks
Database
+ 0 G
postgres@localhost 2 of 4
postgres@localhost [2] 2 of 5
postgres@localhost [3] 3 of 7
class 1 of 3
✓ public
✓ tables 6
>
>
>
>
>
> customer_phones
>
>
>
products
sequences 6
>
✓ Database Objects
>
>
✓ public
>
>
adreeses
customers
orders
extensions 1
languages 4
postgres 1 of 3
"
phone_types
shoppingdb 0 of 3
No schemas selected [...]
✓ Database Objects
Services
access methods 7
casts 229
✿
= » KE?
extensions 1
> languages 4
Server Objects
access methods 7
casts 229
Tx = = = A +
✓postgres@localhost [3]
console 3 s 171 ms
Sa 113333.sql 44 ms
Version Control
12°C
Kısmen güneşli
TODO
SO 113333.sql
1:1
postgres@localhost [3]
products
name varchar(512)
stock
cost
real
real
unit_price real
product_id integer
Powered by yFiles
product_id
自行L S*?
→ Problems ▸ Services
orders
customer_id integer
product_id integer
quantity integer
datetime timestamp
order_id bigint
customer_id
customers
first_name varchar(100)
middle_name varchar(100)
last_name varchar(100)
birth_date
is_active
customer_id
customer_id
date
boolean
integer
customer_id
adreeses
customer_id integer
description varchar(256)
postal_code integer
city varchar(100)
adress_id integer
▬▬
▬▬▬▬
> Output
K
1
phone_types
description varchar(100)
phone_type_id integer
phone_type_id
customer_phones
< 1 row ✓
O Search
customer_id
integer
phone_type_id integer
phone
char(15)
customer_phone_id integer
count(*): bigint
Ç
count =
Ⓡ
▼
Add Configuration...
CSV v
ENG
B
4) O
0
CPU 1%
GPU 15%
VRAM 0%
RAM 73%
FPS --
±F © ☀
11:00 ص
⠀
T.TT/T/-V
Structure Notifications
2
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
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.Recommended textbooks for you
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education