when upper(a.termlength) = 'YEARLY' then dateadd('year',1,orderdate) when upper(a.termlength) = 'MONTHLY' then dateadd('month',1,orderdate) when upper(a.termlength ...

Before we write any SQL we're going to need a database. For this challenge, we'll be using mySQL. At this point, we just want the data on our SQL Server, and we'll improve it later. Using details of ...