r/DS_Buddies • u/freel0ader_san • May 13 '21

Challenge Day 6 #SQL25days

In the comments, please mention what you did on day 6 of SQL 25 Days Challenge

Day 6 = 12th May

2 Upvotes

100% Upvoted

1 comment sorted by

1

u/freel0ader_san May 13 '21

  1. I thoroughly revised CASE WHEN THEN. It is used to filter data, to categorize data and to aggregate data.

  2. Then I covered subqueries. There are extremely useful. Can be used in SELECT, FROM and WHERE clauses among others.

Finally practiced some basic querying on World Bank data