Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
1.6k views
in Computer by (79.4k points)

Consider the table 'Organization' :

             Table: Organization

OrgCode Salary
C101 13,000
C102 5,000
C104 7,000
C105 4,000

(i) With SQL, how can you find the number of rows (records) in the "Organization" table?

(ii) What output will be displayed by the following SQL statement: 

SELECT AVG (Salary) FROM Organization;

1 Answer

+1 vote
by (76.4k points)
selected by
 
Best answer

(i) Select Count (*) from Organization;

(ii) AVG (Salary) : 7250.

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...