database classicmodel

SELECT orders.orderNumber, customers.customerName FROM orders JOIN customers on orders.orderNumber WHERE customers.customerName = 'la rochelle gifts';

SELECT customerName, employees.lastName FROM customers JOIN employees ON customers.salesRepEmployeeNumber = employees.employeeNumber;		

SELECT * FROM orders JOIN customers on orders.customerNumber = customers.customerNumber WHERE customers.contactFirstName = 'carine';

SELECT productlines.textdescription, products.productName from productlines join products on products.productLine = productlines.productLine;

Database booking

SELECT hotel.nome, comuni.nome_comune FROM hotel JOIN comuni on hotel.comune = comuni.id_comune;

SELECT hotel.nome, comuni.nome_comune, localita.nome FROM hotel JOIN comuni on hotel.comune = comuni.id_comune JOIN localita ON hotel.localita = localita.id_localita;

SELECT hotel.nome, comuni.nome_comune, localita.nome, tipologie_strutture.nome FROM hotel JOIN comuni on hotel.comune = comuni.id_comune JOIN localita ON hotel.localita = localita.id_localita JOIN tipologie_strutture on hotel.tipologia_struttura = tipologie_strutture.id_tipologia;

SELECT hotel.nome, comuni.nome_comune, localita.nome, tipologie_strutture.nome, zone.nome FROM hotel JOIN comuni on hotel.comune = comuni.id_comune JOIN localita ON hotel.localita = localita.id_localita JOIN tipologie_strutture on hotel.tipologia_struttura = tipologie_strutture.id_tipologia join zone ON localita.zona = zone.id_zona;