intermediateSQL Query & Schema Design2 of 469
Table1 has 10 rows, Table2 has 20 rows -- what does `SELECT * FROM table1, table2` return? Now delete 10 rows from table1 -- what is the expected count?
Tests whether you recognize the comma join as an implicit CROSS JOIN producing a Cartesian product (200 rows), and that the row count scales with whichever table still has rows, not a fixed delta.
Ready to master this question?
Generate a complete walkthrough — background, the full answer in plain language, a working code example explained line by line, a real-world scenario, common mistakes, and how this same question gets asked in different ways.
Sign in to generate a response