repeating-sql/select-from-invoice-9.6.sql at main · Bujhm/repeating-sql · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
/*
Created by: Ihor Semeniuk
Create Date: 10/12/2023
Decscription: Subquery and DISTINCT | Which tracks are NOT selling
*/
SELECT
    TrackId,
    Composer,
    Name
FROM
    Track
WHERE
    TrackId NOT IN
    (SELECT
        DISTINCT
        TrackId
    FROM
        InvoiceLine

    ORDER BY
        TrackId
    )