ps5 release date code example
Example 1: when does the ps5 come out
12 November 2020: US and select markets
19 November 2020: Rest of world
Example 2: PS5
SELECT
product_name,
list_price,
category_id
FROM
production.products p1
WHERE
list_price IN (
SELECT
MAX (p2.list_price)
FROM
production.products p2
WHERE
p2.category_id = p1.category_id
GROUP BY
p2.category_id
)
ORDER BY
category_id,
product_name;