SQL Fiddle Exercise 4

Our training courses

Book any course as classroom, onsite or online training, or as one-to-one consultancy
Excel Training Basic Excel Advanced Excel VBA Macros Office Scripts Excel Introduction Excel Intermediate Excel Advanced Excel Business Modelling Excel VBA macros Advanced VBA Fast track Excel VBA Basic Office Scripts Advanced Office Scripts Power Platform Training Pure Power BI DAX and fast-track Power Automate Power Apps Introduction to Power BI Adv. Power BI Reports Adv. Power BI Data DAX for Power BI Fast track Power BI Fast track Power BI/DAX Power Automate Desktop Basic Power Automate Advanced Power Automate Fast track Power Automate Power Apps Programming courses SQL training Visual C# training Python training MySQL training Introduction to SQL Advanced SQL Fast track SQL Introduction to Visual C# Intermediate C# Fast track C# Introduction to Python Advanced Python Fast track Python Introduction to MySQL SQL Server training Reporting Services Report Builder Integration Services Analysis Services Reporting Services Advanced SSRS Fast track SSRS Report Builder Introduction to SSIS Advanced SSIS Fast track SSIS SSAS - Tabular Model
Other training resources

Free resources

Read our blogs

Try our exercises

Watch our tutorial videos

View our video shorts

Test your skills

Take a self-paced course

Read recent newsletters

Paid services

License our courseware

Book expert consultancy

Buy our publications

Getting help

Help and support
Our training venues

Where we are

London

Manchester

Where you are

Across the UK

At your site

Online

At your computer
Why we are different

Transparent reviews

562 attributed reviews in the last 3 years

Delivery of courses

Refreshingly small course sizes

Outstandingly good courseware

Whizzy online classrooms

Wise Owls only (no freelancers)

Nicer to work with

Almost no cancellations

We have genuine integrity

We invoice after training

Reliable and established

Review 30+ years of Wise Owl

View our top 100 clients

Search our website

GO
+44 (161) 883 3606 sales@wiseowl.co.uk Web enquiry form
We also send out useful tips in a monthly email newsletter ...

Sign up to newsletter

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! Installing and configuring SQL Fiddle SQL Fiddle Exercise 1 - SELECT SQL Fiddle Exercise 2 - Order By SQL Fiddle Exercise 3 - Numeric Filters SQL Fiddle Exercise 4 - Date Filter (this blog) SQL Fiddle Exercise 5 - Text Filters SQL Fiddle Exercise 6 - Cast or Convert Functions SQL Fiddle Exercise 7 - Conditional Function SQL Fiddle Exercise 8 - Counting Words SQL Fiddle Exercise 9 - Formatted Dates SQL Fiddle Exercise 10 - Date Calculations SQL Fiddle Exercise 11 - Inner Join SQL Fiddle Exercise 12 - Outer Join SQL Fiddle Exercise 13 - Grouping Data SQL Fiddle Exercise 14 - Having SQL Fiddle Exercise 15 - All together now!

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!

SQL Fiddle Exercise 4 - Date Filter

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
Installing and configuring SQL Fiddle SQL Fiddle Exercise 1 - SELECT SQL Fiddle Exercise 2 - Order By SQL Fiddle Exercise 3 - Numeric Filters SQL Fiddle Exercise 4 - Date Filter (this blog) SQL Fiddle Exercise 5 - Text Filters SQL Fiddle Exercise 6 - Cast or Convert Functions SQL Fiddle Exercise 7 - Conditional Function SQL Fiddle Exercise 8 - Counting Words SQL Fiddle Exercise 9 - Formatted Dates SQL Fiddle Exercise 10 - Date Calculations SQL Fiddle Exercise 11 - Inner Join SQL Fiddle Exercise 12 - Outer Join SQL Fiddle Exercise 13 - Grouping Data SQL Fiddle Exercise 14 - Having SQL Fiddle Exercise 15 - All together now!

Parts of this blog

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

Site map

Terms & Conditions

Book any course as classroom, onsite or online training, or as one-to-one consultancy

Free resources

Paid services

Getting help

Where we are

Where you are

Online

Transparent reviews

Delivery of courses

Nicer to work with

Reliable and established

Our training courses

C#

Excel

MySQL

Power Apps

Power Automate

Power BI and DAX

Python

Report Builder

SQL

SQL Server

VBA Macros

Other training resources

Blogs

Exercises

YouTube tutorials

YouTube shorts

Test your skills

Consultancy

Courseware

Self-paced courses

Newsletters

Publications

Our training venues

London

Manchester

Across the UK

At your site

Online

Why we are different

Hundreds of published reviews

Small class sizes

Outstanding courseware

Online classroom

(Almost) no cancellations

Wise Owl trainers only

Genuine integrity

Invoices after training

30+ years of Wise Owl

Our top 100 clients

BLOGS BY TOPIC

BLOGS BY AUTHOR

SQL Fiddle Exercise 4 - Date Filter

Head office

London

Manchester