Question

When we type first letter of a contact name in our contact list in our mobile phones all the names containing that character are displayed. Can you relate SQL statement with the process? List other real life situations where you can visualize an SQL statement in operation.

Answer 1

SELECT * FROM CONTACTS
WHERE Name LIKE 'A%';

This displays all contact names starting with A.

Other real-life situations where SQL statements are used:

• Online shopping: Searching for products by name or category.
• Banking: Retrieving account details and transaction records.
• Schools: Finding students’ marks, attendance, or other records.
• Hospitals: Searching for a patient's records.
• Railway/Airline booking: Checking available seats and booking details.
• Libraries: Searching for a particular book or author.