-- Create a unified contact list of all customers AND employees. -- Include their name, email, and role ('Customer' or 'Employee'). -- Remove any duplicates by email. -- UNION combines result sets and ...
R2 SQL now supports window functions, SELECT DISTINCT, set operations, and additional aggregates, making it easier to write analytical queries without preprocessing your data elsewhere.