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

Authored by swaas 3

Other

Professional Development

Used 2+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

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)

Access all questions and much more by creating a free account

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

CryptoFactories.io v1.0

Quiz

•

KG - Professional Dev...

20 questions

123Go

Quiz

•

Professional Development

20 questions

riddles

Quiz

•

KG - Professional Dev...

20 questions

shoe quiz

Quiz

•

KG - Professional Dev...

20 questions

Woodwork Saws

Quiz

•

3rd Grade - Professio...

20 questions

Quizizz 4 JAVA

Quiz

•

Professional Development

20 questions

CPL Acft Tech - Carburation

Quiz

•

Professional Development

20 questions

Security K3

Quiz

•

Professional Development

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

10 questions

Probability Practice

Quiz

•

4th Grade

15 questions

Probability on Number LIne

Quiz

•

4th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

6 questions

Appropriate Chromebook Usage

Lesson

•

7th Grade

10 questions

Greek Bases tele and phon

Quiz

•

6th - 8th Grade

Discover more resources for Other

20 questions

Black History Month Trivia Game #1

Quiz

•

Professional Development

20 questions

90s Cartoons

Quiz

•

Professional Development

12 questions

Mardi Gras Trivia

Quiz

•

Professional Development

7 questions

Copy of G5_U5_L14_22-23

Lesson

•

KG - Professional Dev...

12 questions

Unit 5: Puerto Rico W1

Quiz

•

Professional Development

42 questions

LOTE_SPN2 5WEEK2 Day 4 We They Actividad 3

Quiz

•

Professional Development

15 questions

Balance Equations Hangers

Quiz

•

Professional Development

31 questions

Servsafe Food Manager Practice Test 2021- Part 1

Quiz

•

9th Grade - Professio...

Postgree SQL Day-1

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)

Access all questions and much more by creating a free account

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)