What is the difference between the order by and group by clauses when used along with a select statement? Explain with an example.

Prerna received an email from her bank stating that there is a problem with her account. The email provides instructions and a link, by clicking on which she can log in to her account and fix the problem. Help Prerna by telling her the precautions she should take when she receives these types of emails.

Consider the dataframe SHOP given below:

        Item     Qty    City     Price
101   Biscuit    100   Delhi       10
102   Jam        110   Kolkata     25
103   Coffee     200   Kolkata     55
104   Sauce       56   Mumbai      55
105   Chocolate  170   Delhi       25

Write commands to:

(i) Write short code to show the information having city = "Delhi".

(ii) Calculate Qty * Price and assign to column 'Net_Price'.

(iii) Display Items of all rows.

Consider the following table named "Student":

Write the SQL functions which will perform the following operations:

(i) To show the sum of fees of all students.

(ii) To display maximum and minimum marks.

(iii) To count different types of grades available.

(iv) Write a query to count grade-wise total number of students.