Member-only story
Analyze your data using with SQL’s Powerful Grouping and Filtering Tools
In the previous articles (start the series from here) of this series on Structured Query Language (SQL), we successfully created our tables, inserted data into them, and learned everything about the SELECT and WHERE statement to select and filter data from our tables. Building on this, we will now do some advanced filtering which will include use of Wildcards and various boolean operators.
Note: All the code for this article series is available on my github here
Originally published on my substack. Feel free to subscribe
Recap (Table Structure):
In the previous articles, we successfully set up our SQL environment and created two tables: YoutubeChannel and ChannelStats. The YoutubeChannel table includes columns for ChannelID, ChannelName, and DateCreated, while the ChannelStats table features columns for ChannelID, SubscribersCount, TotalViews, and Date.
The LIKE Operator and Wildcards
The LIKE operator in SQL is used to search for a specified pattern in a column. The % symbol is used as a wildcard character to represent any number of characters in the pattern. In our case, we are mostly checking with only one…
