zad1
SELECT *
FROM products as p
where p.CategoryID in(
    					SELECT c.categoryID
    					FROM categories as c
   						WHERE c.CategoryName LIKE "C%"
    				)




SELECT *
FROM products as p
where p.CategoryID in(
    					SELECT c.categoryID
    					FROM categories as c
   						WHERE c.CategoryName = "Beverages" or c.categoryName = "Seafood"
    				)








zad2



SELECT *
FROM orders as o
where o.customerID in(
    					SELECT c.CustomerID
    					FROM customers as c
   						WHERE c.country IN ("USA", "UK")

    				)



SELECT *
FROM orders as o
where o.EmployeeID in(
    					SELECT e.EmployeeID
    					FROM employees as e
   						WHERE e.FirstName LIKE "A%"


    )