Customer inventory retrieve the names and ids all faculty members

fee_detail Table:

doctor Table:

FIELD NAME	DATA TYPE
inventory_identification_no	Int(50)
name	Varchar(50)
description	Varchar(50)
price	Varchar(50)
quantity	Varchar(50)
safety_stock_level	Varchar(50)

doctor.customer_identification_no=customer.customer_identification_no

3: Retrieve the names and IDs of all faculty members, arranged in alphabetical order by name :

4: Retrieve the number of students that are taking MTH103C :

Ans: Select count (a.StudentID,) from student a, Enrolment b
Where a. StudentID = b.StudentID
And b.CourseNumber = 'MTH103C'

set Major = NULL

where StudentID = ‘S1013’

1: SQL statements for “The complete Student table”:

Ans: SELECT * FROM STUDENT

Ans: SELECT count (Student_Number) Number of student FROM student

4: The number of students with a grade of greater than 50:

Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.

SELECT*FROM "PartB"."dbo"."client" ORDER BY name DESC;

Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.

Repeat query (7) but also display all clients who have never ordered anything.
Display the client name and order date for all orders using the natural join keywords.
Display the second to fifth characters in each client name.
Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth.
Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.
Using a set operator, display the client number of all clients who have never placed an order.
Display the client number and the value of the highest value order placed by that client.
Display the earliest shipping date in the format: DD/MON/YYYY