SELECT * FROM bricks,colors; Which two statements are true?

For the SELECT statement from two tables without a JOIN clause:

Option B: You can add a WHERE clause with filtering criteria.

A WHERE clause can be added to a query to filter the results based on specified conditions.

Option E: It returns the same rows as SELECT * FROM bricks CROSS JOIN colors.

A comma-separated list of tables in a FROM clause is equivalent to a CROSS JOIN, resulting in a

Cartesian product of the tables.

Options A, C, and D are incorrect because:

Option A: You cannot add an ON clause without changing the comma-separated FROM clause to a

proper JOIN.

Option C: It returns the Cartesian product, not the sum, of the rows from BRICKS and COLORS.

Option D: A USING clause is not applicable without changing the syntax to a proper JOIN.