Hi,   Please help me understand the difference between date () and today () function. Are they always the same ?     Thanks !       ... View more

Hi,   Please help me to solve the below question -   Refer to the following tables:   AGENT_INFO   AGENT_CODE  AGENT_NAME            WORKING_AREA        PHONE_NO         A012        Lucida                San Jose            044-52981425     A005        Anderson              Brisbane             045-21447739     A001        Subbarao              Bangalore           077-12346674     A002        Mukesh                Mumbai              029-12358964     A006        McDen                 London              078-22255588     A004        Ivan                  Torento             008-22544166     A009        Benjamin              Hampshair           008-22536178        CUSTOMER_INFO AGENT_CODE CUST_NAME CUST_CITY AMT PHONE_NO CUST_CODE A002 Holmes London 4000 BBBBBBB  C00013 A006 Micheal New York 6000 CCCCCCC  C00001 A004 Albert New York 6000 BBBBSBB  C00020 A006 Ravindran Bangalore 8000 AVAVAVA  C00025 A012 Cook London 6000 FSDDSDF  C00024 A005 Stuart London 11000 GFSGERS  C00015 A009 Bolt New York 3000 DDNRDRH  C00002 A005 Fleming Brisbane 5000 NHBGVFC  C00018 A012 Jacks Brisbane 7000 WERTGDF  C00021   AGENT_COMMISON:   CUST_CODE AGENT_ COMMISSION  C00013 0.12  C00001 0.13  C00020 0.14  C00025 0.11  C00024 0.15  C00015 0.15  C00002 0.11  C00018 0.16  C00021 0.22         Q 1 Write a query to list down agents with no customers   Q 2 Write a query to select the agent with most no of customers   Q 3 List all customers who are the same working location of the Agent   Q 4 What is the total commission amount for each agent?   Q 5 Range the table in ascending order of the work location with highest collection     Thanks, in advance ! 🙂 ... View more