Subquery Database SQL

Use Syntax Max to Highest Quantity

Transaction 1 1..* PK JID Transaction char(6) FK IDComputer char(6) FK JIDClient char(6) Transaction Date date QuantityOfEach Computer int Computer PK IDComputer char(6) FK IDComputerBrand char(6) ComputerName varchar(100) Computer Type varchar(100) Computer Price int 1..* 1..* 1 1 Client PK IDClient ClientName ComputerBrand PK IDComputerBrand char(6) ComputerBrandName varchar(100) ClientDateOfBirth ClientEmail ClientAddress ClientCity char(6) varchar(100) date varchar(100) varchar(100) varchar(100) Question Database SQL Subquery Show (use SELECT in SELECT. Example : Select .. From .., (Select .. From ..)) IDComputerBrand, ComputerBrandName, IDClient, ClientEmail, Quantity (get from sum Quantity of computers of the Brand) for the highest Quantity of the brand, client that has the email format '@yahoo.com and IDClient ending in odd number. Can Use Join and Group By