Question Database SQL As Subquery

Sales 1 Computer Brand PK IDComputerBrand char(6) ComputerBrand Name varchar(100) 1 Computer PK IDComputer char(6) FK IDComputerBrand char(6) ComputerBrand varchar(100) ComputerName varchar(100) Computer Price int 1. 1. Supplier PK IDSupplier char(6) FK IDComputer char(6) SupplierName varchar(100) SupplierContact Number varchar(20) SupplierAddress varchar(100) 1 PKIDSales char(6) SalesName varchar(100) SalesDate of Birth date SalesGencler varchar(100) Sales Contact Number varchar(20) Sales Address varchar(100) SalesSalary int 1 1 1 1 1.. . Client 1 PK IDClient FK IDComputer ClientName ClientDateOfBirth ClientGender ClientEmail ClientAddress char(6) char(6) varchar(100) date varchar(20) varchar(100) varchar(100) Sales Transaction PK Sales Transaction char(6) 6) FK IDSales char(6) FK IDClient char(6) TransactionDate Sales date ComputerSold int QuantityOfSales int 1. 1.- Buying Transaction PK IDBuying Transaction char(6) FK IDSales char(6) FK Supplier char(6) Transaction Date Buying date Buying Computer int QuantityOlBuying lint 1. Question Database SQL Subquery Show (use SELECT in SELECT and Join) IDComputerBrand, ComputerBrand, IDClient, ClientEmail (get from replace format email to '@rocketmail.com'), 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. Please provide a screenshot of the proof of the query that has been made in the database view