

    SELECT ord.Order_Number, ord.Total_Amount, cust.First_Name, cust.Last_Name
    FROM Customer.Orders ord
       JOIN Customer.Customer cust
       ON ord.Customer_Id = cust.Id
    WHERE ord.Customer_Id = 33;

    SELECT p.Product_Name, s.Company_Name
    FROM Customer.Supplier s
      JOIN Customer.Product p
      ON p.Supplier_Id = s.Id
    WHERE s.Id = 2;

    SELECT c2.Name as Capital, c1.Name as Country
    FROM World.Country c1
      JOIN World.City c2
      ON c1.Capital = c2.Id
    WHERE c1.Continent in ('Europe', 'Asia')
    ORDER BY Capital;
    SELECT city.Name, country.Name as "Country"
    FROM World.Country country
       JOIN World.City city
       ON country.Code = city.Country_Code
    WHERE country.Name = 'Japan'
    ORDER BY city.Name;

    SELECT c2.Name as Capital, c1.Name as Country
    FROM World.Country c1
      JOIN World.City c2
      ON c1.Capital = c2.Id
    WHERE c1.Continent in ('Europe', 'Asia')
    ORDER BY Capital;

