β β (b) Display the names of the employees whose salary are more than 20000 but less than 30000.
-
See the Output π₯
-
See the Output π₯
-
See the Output π₯
-
See the Output π₯
β An account can be saving account or a current account. Check Atype in 'S' or 'C'. A customer can have both types of accounts.
β β (b) Develop a SQL query to list the details of customers who have a saving account and a current account.
β β (c) Develop a SQL query to list the details of branches and the number of accounts in each branch.
β β (d) Develop a SQL query to list the details of branches where the number of accounts is less than the average number of accounts in all branches.
-
See the Output π₯