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

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 ...
Read more

SQL statements DDL (data Definition Language)

Image
  SQL Statements : SQL comprises four main language statements : Which are DDL(Data definition language) DML(Data manipulation language) DCL (Data Control Language) TCL (Transaction Control Language) In this blog, I’ll discuss the first sublanguage of SQL which is DDL from where the whole process of creating a database is started.   How to create the SQL statement: There are certain rules that must be followed to create precise SQL statements. Each and every SQL sublanguage have its own statements as shown in the above picture. So let’s see the DDL statements.   DDL(Data Definition Language): DDL is a language that is used to create the structure of the database and then later on the user can alter the table if required. §   SQL Create Table Statement : Create statement is used to create a new table .it’s syntax is as follows. CREATE TABLE table_name (column1 datatype, column2 datatype, columns datatype); Where N is a variable number of columns and datat...
Read more

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 ...
Read more