write queries for following scieniores max users visited date ,user with maximum transitions date,user visited but not done any transition.

1. 

  SELECT TOP (1) UserVisitDate AS MaxUserVisitDate FROM

  (

     SELECT date AS UserVisitDate, COUNT(*) AS UserVisitCount 

     FROM Visit

     GROUP BY visit_date

    ) DT ORDER By UserVisitCount DSC;

  

2. 

    SELECT TOP (1) transaction_date AS MaxAmountTransactionDate FROM

  (

     SELECT transaction_date, SUM(amount) AS TransactionAmountTotal 

     FROM Transaction

     GROUP BY transaction_date

    ) DT ORDER By TransactionAmountTotal DSC;

  

3.

   SELECT TOP (1) user_id AS MaxTransactionAmountUser FROM

  (

     SELECT user_id, SUM(amount) AS TransactionAmountTotal 

     FROM Transaction

     GROUP BY user_id

    ) DT ORDER By TransactionAmountTotal DSC;

  

  

4. SELECT AVG(amount) AS AvgTransactionPerDay FROM Transaction GROUP By transaction_date;

5. SELECT user_id AS VisitedUserWithNoTransaction 

   From Visit

   WHERE user_id NOT IN ( SELECT user_id FROM Transactions WHERE user_id is NOT NULL);