select customerNumber from customers where salesRepEmployeeNumber = 1501;


select orderNumber from orders where customerNumber in (186, 187, 201, 240, 311, 324, 334, 489);


select productCode from orderdetails where orderNumber = 10123;


select productName, buyPrice from products where productCode = 'S18_1589';

select employeeNumber, lastName, firstName, count(orderNumber) from employees inner join customers
on employeeNumber = salesRepEmployeeNumber inner join 
orders using (customerNumber) where employees.lastName = 'Bott';


emp id = 1501
