Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The following questions are based on the tables test1: select * from test1; tt | discount ------------------------------------ 14 | 0.00 9999 | 0.00 10 |
The following questions are based on the tables test1:
select * from test1;
tt | discount
------------------------------------
14 | 0.00
9999 | 0.00
10 | 22.22
11 | 0.00
null | 11.00
(5 rows)
Write down the results of executing the following
1) select count(*) from test1;
2) select count(tt) from test1;
3) select count(distinct discount) from test1;
4) select avg(tt) from test1;
5) select avg(distinct discount) from test1;
6) select * from test1 t1 natural inner join test1 t2;
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