I have these tables:
I want to write a query where I can get the last name of the employee with the largest order quantity. I managed to write these following queries:
'Selects biggest purchase from OrderDetails' SELECT MAX(Quantity) FROM [OrderDetails]; 'Selects the OrderID of orders' SELECT OrderID FROM [OrderDetails]; SELECT EmployeeID FROM [Orders] SELECT OrderID FROM [Orders]
But I don't know how to combine them.