SQL query to display the total number of students whose names start with 'A' from the child details table.

• Use the SELECT statement to retrieve data from the table.

• Use the COUNT function to count the n...read more

SELECT COUNT(*) AS total_students

FROM child_details

WHERE child_name LIKE 'A%';