SQL-Lesson #5

 

DOWNLOAD DATABASE

 

https://www.mysqltutorial.org/mysql-sample-database.aspx

SUBQUERY

SELECT 
    lastName, firstName
FROM
    employees
WHERE
    officeCode IN (SELECT 
            officeCode
        FROM
            offices
        WHERE
            country = 'USA');

STRUCTURE

SUBQUERY

SELECT 
    customerNumber, 
    checkNumber, 
    amount
FROM
    payments
WHERE
    amount = (SELECT MAX(amount) FROM payments);

SUBQUERY

SELECT 
    customerNumber, 
    checkNumber, 
    amount
FROM
    payments
WHERE
    amount > (SELECT 
            AVG(amount)
        FROM
            payments);

SUBQUERY

SELECT 
    customerNumber, customerName
FROM
    customers
WHERE
    customerNumber NOT IN (SELECT DISTINCT
            customerNumber
        FROM
            orders);

SQL - Lesson #5

By TenantCloud

SQL - Lesson #5

  • 155

More from TenantCloud