Do you really know SQL? 😊
Day 19/30
What does this query return: SELECT COALESCE(Email, 'no-email') FROM Users;
A. Replaces empty strings with NULL
B. Converts NULL emails to 'no-email'
C. Converts all values to strings
D. Removes NULL rows
Do you really know SQL? 😊
Day 7/30
How do you retrieve all rows where Email is NOT NULL?
A. SELECT * FROM Users WHERE Email != NULL;
B. SELECT * FROM Users WHERE Email NOT NULL;
C. SELECT * FROM Users WHERE Email IS NOT NULL;
D. SELECT * FROM Users WHERE Email <> "";
Do you really know SQL? 😊
Day 5/30
Which statement returns all customers whose name ends with “son”?
A. SELECT * FROM Customers WHERE Name LIKE 'son%';
B. SELECT * FROM Customers WHERE Name LIKE '%son';
C. SELECT * FROM Customers WHERE Name = '%son';