SQL Query Online Test

 

SQL Query Test

 

Consider the following table.

Staff_NO

Emm_Name

Position

Gender

Salary

Branch_NO

SL41

Jhon

Manager

M

30000

D005

SG5

Clark

Supervisor

M

23000

D007

SA9

Mark

Asistant

M

18000

D005

SG14

Tina

Manager

F

9000

D006

SG37

Adam

Clerk

M

24000

D005

SL21

Julie

Asistant

F

18000

D007

SA56

Smith

Clerk

M

12000

D007

 

👉Write a query to Retrieve the List of salaries of all employees arranged in descending order of salaries.

👉Write a query to find the Minimum, Maximum and Average salary of Staff.

👉Write a query to find the number of Staff members working in each Branch and Sum of their salaries.

👉Write a query to find the  Branch office with more than one staff member.

ANSWER KEY

Comments

Post a Comment

your feedback is valuable.

Popular posts from this blog

SQL statements (Data Manipulation Language)

Image
  Writing SQL Commands: Before knowing what are DML commands have a glance at what are SQL commands and how to write these commands. well, Commands are the SQL statements that are written by following some syntax to extract data from the database mainly and later on perform some other operations to manage or retain the data according to constraint(rules) in the database. SQL statements consist of reserved words and User-defined words. Reserved words have some specific meanings and can be as it is. They must be spelled properly as required and can not be split across lines such as SELECT ,ALTER,UPDATE etc. User-defined words are created by the user (according to the syntax rule) and represent the name of various database objects such as table column Views etc. Although SQL is a free format language the statements can be made more readable by following these steps. Ø Each clause in a statement should begin on a new line. Ø Uppercase letters are used to represent Reserved word
Read more

What is SQL

Image
  What Is SQL? SQL is a structured query language. It was developed by IBM (international business Machine). It is endorsed as a national standard by the American national standard institute. It is the language that is used frequently for relational data models. SQL works with database programs like MS Access, DB2, Informix, Oracle, MS SQL Server, Sybase. What is SQL used for: SQL is used for extracting data from the database. Now,  what is the database?  A database is a large collection of data that is organized in a good manner way so that the user can access data efficiently and that data is stored in a compact(taking less space) manner on a computer. when we talk about Database here is another term used parallelly with it which is DBMS . Database Management System (DBMS) is a program that is used to create and maintain the data of the database. Let’s suppose we have a database “Employee” that contain the information of all employees who work in an organization like their Id,
Read more

Types of joins in SQL Equi and Non_Equi join

Image
  Types of Joins in SQL: As the starter of SQL when you will apply any query it has some limitation that the resultant table is generated from one table only but there is some situations arise in which we may have to retrieve data from multiple tables and in that case we will use JOIN operation. If we want to generate the joined table (which will be the resultant table) from row pairing then two tables must have columns with the same values. Joining is the process of combining rows from multiple tables. Through joining, we can generate a short-lived table with all accessed columns from multiple tables that are specified in join. So here we will discuss different types of joins in SQL. How can we perform SQL joins: For performing JOIN we can use more than one table name after FROM keyword. These are obviously the name of those tables from which we want to extract data. Both table names should be written by using a separator or comma between them. WHERE Clause is used to specify the
Read more