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…
SQL Joins is an SQL clause and it combines data from multiple tables on basis of related columns between them. So you have designed a wonderful…