One key thing they asked me was to write and explain basic SQL queries, including SELECT, JOIN, GROUP BY, and WHERE clauses to retrieve and filter data from relational tables.
Sigiloso
I explained each clause with simple examples. For instance, I demonstrated a SELECT query to retrieve customer data, used a JOIN to combine orders with customer information, and applied GROUP BY to show total sales per customer. I also used a WHERE clause to filter results based on conditions like order date or status. I made sure to highlight the logical flow and purpose of each clause in the query.