562 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Practise SQL in your browser with SQL Fiddle
Part five of a sixteen-part series of blogs
Some of our poor delegates don't have the luxury of a home computer to install SQL on (even worse some have made bad life choices and picked a Mac). The good news is that you can still practise your SQL skills in your web browser, using the impressive SQL Fiddle site. Have no fear, SQL Fiddle is here, a browser based sandbox to bring you cheer!
Write a query that only returns sales made in the second half of the current month. In the model we provided that can be the year 2020 or 2021 or even both!
For transactions in June, there are 2 sales made in the second half of the month in 2021.
Expanding the clause to include both 2020 and 2021 will be a little bit harder.
This data has been ordered, but it's for you to work out how!
Keep in mind that when working with dates using the reverse format yyyy-mm-dd is usually the safest method.
Check out the answer here.
|Parts of this blog|
25 Aytoun Street