Purchaser CREATE TABLE purchaser ( customer_id INT PRIMARY KEY AUTO_INCREMENT, // primary key and auto increment name VARCHAR(100) NOT NULL, email VARCHAR(100) UNIQUE NOT NULL, // email must be unique ...
Fetch the employee number, first name and last name of those employees who are working as Sales Rep reporting to employee with employeenumber 1102 (Refer employee table) Company wants to analyse ...