Computer scienceFundamentalsSQL and DatabasesBasics SQLFunctions and operations

Set operations

Only marriages

Report a typo

Choose a correct query that selects all distinct dates from the table marriages (marriage_date DATE, spouses_last_name VARCHAR(40)) that are not in the table divorces (divorce_date DATE, spouses_last_name VARCHAR(40), divorce_reason VARCHAR(70)).

Select one option from the list

SELECT divorce_date FROM divorces MINUS SELECT marriage_date FROM marriages

SELECT marriage_date FROM marriages MINUS SELECT divorce_date FROM divorces

SELECT marriage_date FROM marriages INTERSECT SELECT divorce_date FROM divorces

SELECT marriage_date FROM marriages UNION SELECT divorce_date FROM divorces

___

Create a free account to access the full topic