Use a Innerjoin to get the total QUANTITY sold per product.(ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NOT IN SMALL LETTERS) PRODUCTS P(PRODUCTID, PRODUCTNAME) SALES S(PRODUCTID, QUANTITY) ALIAS SUM COLUMN Name was TOTALSOLD

SELECT P.PRODUCTNAME, SUM(S.QUANTITY) AS TOTALSOLD FROM PRODUCTS P INNER JOIN SALES S ON P.PRODUCTID= S.PRODUCTID GROUP BY P.PRODUCTNAME

Get customers who ordered a specific product (say ‘Milk’). inner join(ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NOT IN SMALL LETTERS) Tables: ORDERS O(ORDERID, CUSTOMERID) ORDERDETAILS OD(ORDERID, PRODUCTID) PRODUCTS P(PRODUCTID, PRODUCTNAME) CUSTOMERS C(CUSTOMERID, CUSTOMERNAME)

SELECT DISTINCT C.CUSTOMERNAME FROM CUSTOMERS C INNER JOIN ORDERS O ON C.CUSTOMERID = O.CUSTOMERID INNER JOIN ORDERDETAILS OD ON O.ORDERID = OD.ORDERID INNER JOIN PRODUCTS P ON OD.PRODUCTID = P.PRODUCTID WHERE P.PRODUCTNAME = 'Milk'

Stored Procedure for Insert (CRUD) CREATE PROCEDURE InsertEmployee @Name NVARCHAR(50), @Salary DECIMAL(10,2), @DepartmentID INT AS BEGIN INSERT INTO Employees (Name, Salary, DepartmentID) VALUES (@Name, @Salary, @DepartmentID); END; (VALUES : Name= John Doe, Salary =60000, DepartmentID = 2)

EXEC InsertEmployee @Name = 'John Doe', @Salary = 60000, @DepartmentID = 2

Update a record TABLE: Products(P_ID, ProductName,Price) Updates the price of Pepsi to 35.

UPDATE Products SET Price = 35 WHERE ProductName = 'Pepsi'

Retrieves only the Name and Department columns. from the Students Table

SELECT Name, Department FROM Students

Names containing ‘an’ Write query for Employees Table Table: Employees(EmpId, EmpName)

SELECT * FROM Employees WHERE EmpName LIKE '%an%'

Names where second letter is ‘a’ Table: Employees(EmpId, EmpName)

SELECT * FROM Employees WHERE EmpName LIKE '_a%'

Find employees whose name starts with 'A' and ends with 'L' This will return names like Anil , where the name starts with A and ends with L Table: Employees(EmpId, EmpName)

SELECT * FROM Employees WHERE EmpName LIKE 'A%L'

What will this query return? SELECT Department, AVG(Salary) AS AvgSalary FROM Employees GROUP BY Department HAVING AVG(Salary) > 50000;

Departments with average salary more than 50,000

Employees earning more than 50,000

SELECT E.Name , D.DeptName FROM Employees E JOIN Departments D ON E.Department = D.DeptCode;

Returns only employees with matching department codes

Returns all employees regardless of department

Query result? SELECT City, COUNT(CustomerID) FROM Customers GROUP BY City HAVING COUNT(CustomerID) < 5;

Cities with fewer than 5 customers

Cities with more than 5 customers

SELECT D.DepartmentName, E.Name FROM Departments D RIGHT JOIN Employees E ON D.Id = E.DeptId;

All employees even if they have no department

Postgree SQL Day-1

Professional Development

•

25 Qs

Similar activities

OBM Revision

Professional Development

•

20 Qs

G Quiz 1

10th Grade - Professional Development

•

20 Qs

The Halloween Probe

Professional Development

•

20 Qs

Anti Fraud Non KP

Professional Development

•

20 Qs

Harry Potter

2nd Grade - Professional Development

•

20 Qs

General Knowledge (hard)

KG - Professional Development

•

20 Qs

Quality quiz

Professional Development

•

20 Qs

HUT TN 47 TAHUN

Professional Development

•

20 Qs

Postgree SQL Day-1

Quiz

•

Other

•

Professional Development

•

Practice Problem

•

Medium

swaas 3

Used 2+ times

FREE Resource

25 questions

Show all answers

FILL IN THE BLANK QUESTION

1 min • 1 pt

Which SQL statement is used to select all records from a table named 'CUSTOMERS'?(ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NOT IN SMALL LETTERS)

FILL IN THE BLANK QUESTION

1 min • 1 pt

Filter records using WHERE
Retrieves EMPLOYEES who work in the IT DEPARMENT?(ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NOT IN SMALL LETTERS)

FILL IN THE BLANK QUESTION

1 min • 1 pt

Use LIKE for pattern matching
Finds CUSTOMERS whose CUSTOMERNAME start with "A".(ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NOT IN SMALL LETTERS)

FILL IN THE BLANK QUESTION

2 mins • 1 pt

Lists PRODUCTS ordered by PRICE in descending order.(ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NOT IN SMALL LETTERS and SPACE)

FILL IN THE BLANK QUESTION

2 mins • 1 pt

Aggregate function with GROUP BY
Write a SQL query to COUNT THE NUMBER OF EMPLOYEES IN EACH DEPARTMENT and name the count column as TOTALEMPLOYEES (THE ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NO SMALL LETTERS).

FILL IN THE BLANK QUESTION

1 min • 1 pt

Delete a record
Deletes the PRODUCTNAME "PEPSI" from the PRODUCTS table.(ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NOT IN SMALL LETTERS)

FILL IN THE BLANK QUESTION

2 mins • 1 pt

Write a query to retrieve employee names and their department names.(ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NOT IN SMALL LETTERS)
Tables:
EMPLOYEES E(EMPLOYEEID, NAME, DEPARTMENTID)
DEPARTMENTS D(DEPARTMENTID, DEPARTMENTNAME)

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

20 questions

Mock CBT 01 OHS 601 (Diploma)

Quiz

•

University - Professi...

20 questions

GK Quiz-VIII

Quiz

•

KG - Professional Dev...

20 questions

Trick Questions

Quiz

•

3rd Grade - Professio...

20 questions

Le PES Marché

Quiz

•

Professional Development

20 questions

Customer Service - Knowledge Check 1

Quiz

•

Professional Development

20 questions

Entertainment Quiz

Quiz

•

Professional Development

20 questions

Maintenance quiz

Quiz

•

Professional Development

20 questions

League of Leggos

Quiz

•

Professional Development

Popular Resources on Wayground

5 questions

This is not a...winter edition (Drawing game)

Quiz

•

1st - 5th Grade

15 questions

4:3 Model Multiplication of Decimals by Whole Numbers

Quiz

•

5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

10 questions

The Best Christmas Pageant Ever Chapters 1 & 2

Quiz

•

4th Grade

12 questions

Unit 4 Review Day

Quiz

•

3rd Grade

10 questions

Identify Iconic Christmas Movie Scenes

Interactive video

•

6th - 10th Grade

20 questions

Christmas Trivia

Quiz

•

6th - 8th Grade

18 questions

Kids Christmas Trivia

Quiz

•

KG - 5th Grade

Discover more resources for Other

26 questions

Christmas Movie Trivia

Lesson

•

8th Grade - Professio...

10 questions

Christmas Trivia

Quiz

•

Professional Development

21 questions

Name that Holiday Movie

Quiz

•

Professional Development

Postgree SQL Day-1

25 questions

Which SQL statement is used to select all records from a table named 'CUSTOMERS'?(ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NOT IN SMALL LETTERS)

Filter records using WHERE Retrieves EMPLOYEES who work in the IT DEPARMENT?(ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NOT IN SMALL LETTERS)

Use LIKE for pattern matchingFinds CUSTOMERS whose CUSTOMERNAME start with "A".(ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NOT IN SMALL LETTERS)

Lists PRODUCTS ordered by PRICE in descending order.(ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NOT IN SMALL LETTERS and SPACE)

Aggregate function with GROUP BYWrite a SQL query to COUNT THE NUMBER OF EMPLOYEES IN EACH DEPARTMENT and name the count column as TOTALEMPLOYEES (THE ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NO SMALL LETTERS).

Delete a recordDeletes the PRODUCTNAME "PEPSI" from the PRODUCTS table.(ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NOT IN SMALL LETTERS)

Write a query to retrieve employee names and their department names.(ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NOT IN SMALL LETTERS)Tables:EMPLOYEES E(EMPLOYEEID, NAME, DEPARTMENTID)DEPARTMENTS D(DEPARTMENTID, DEPARTMENTNAME)

Use a Innerjoin to get the total QUANTITY sold per product.(ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NOT IN SMALL LETTERS)PRODUCTS P(PRODUCTID, PRODUCTNAME)SALES S(PRODUCTID, QUANTITY) ALIAS SUM COLUMN Name was TOTALSOLD

Get customers who ordered a specific product (say ‘Milk’). inner join(ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NOT IN SMALL LETTERS)Tables:ORDERS O(ORDERID, CUSTOMERID)ORDERDETAILS OD(ORDERID, PRODUCTID)PRODUCTS P(PRODUCTID, PRODUCTNAME)CUSTOMERS C(CUSTOMERID, CUSTOMERNAME)

Stored Procedure for Insert (CRUD)CREATE PROCEDURE InsertEmployee @Name NVARCHAR(50), @Salary DECIMAL(10,2), @DepartmentID INTASBEGIN INSERT INTO Employees (Name, Salary, DepartmentID) VALUES (@Name, @Salary, @DepartmentID);END;(VALUES : Name= John Doe, Salary =60000, DepartmentID = 2)

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Other

Filter records using WHERE
Retrieves EMPLOYEES who work in the IT DEPARMENT?(ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NOT IN SMALL LETTERS)

Use LIKE for pattern matching
Finds CUSTOMERS whose CUSTOMERNAME start with "A".(ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NOT IN SMALL LETTERS)

Aggregate function with GROUP BY
Write a SQL query to COUNT THE NUMBER OF EMPLOYEES IN EACH DEPARTMENT and name the count column as TOTALEMPLOYEES (THE ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NO SMALL LETTERS).

Delete a record
Deletes the PRODUCTNAME "PEPSI" from the PRODUCTS table.(ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NOT IN SMALL LETTERS)

Write a query to retrieve employee names and their department names.(ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NOT IN SMALL LETTERS)
Tables:
EMPLOYEES E(EMPLOYEEID, NAME, DEPARTMENTID)
DEPARTMENTS D(DEPARTMENTID, DEPARTMENTNAME)

Use a Innerjoin to get the total QUANTITY sold per product.(ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NOT IN SMALL LETTERS)
PRODUCTS P(PRODUCTID, PRODUCTNAME)
SALES S(PRODUCTID, QUANTITY) ALIAS SUM COLUMN Name was TOTALSOLD

Get customers who ordered a specific product (say ‘Milk’). inner join(ANSWER MUST BE WRITTEN IN CAPITAL LETTERS ONLY, NOT IN SMALL LETTERS)
Tables:
ORDERS O(ORDERID, CUSTOMERID)
ORDERDETAILS OD(ORDERID, PRODUCTID)
PRODUCTS P(PRODUCTID, PRODUCTNAME)
CUSTOMERS C(CUSTOMERID, CUSTOMERNAME)

Stored Procedure for Insert (CRUD)
CREATE PROCEDURE InsertEmployee
@Name NVARCHAR(50),
@Salary DECIMAL(10,2),
@DepartmentID INT
AS
BEGIN
INSERT INTO Employees (Name, Salary, DepartmentID)
VALUES (@Name, @Salary, @DepartmentID);
END;
(VALUES : Name= John Doe, Salary =60000, DepartmentID = 2)