SQL Subquery is another tool SQL Server has which can be used to fetch data from other tables to be used in main query according to...