Answered step by step
Verified Expert Solution
Link Copied!

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

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

SQL Instant Reference

Authors: Gruber, Martin Gruber

2nd Edition

0782125395, 9780782125399

More Books

Students also viewed these Databases questions