Question

SQL User Logins Your table: maintable_YH8M8 MySQL version: 5.5.56-log In this MySQL challenge, the table provided shows all new users signing up on a specific date in the format YYYY-MM-DD. Your query should output the change from one month to the next. Because the first month has no preceding month, your output should skip that row. Your output should look like the following table. Month | MonthToMonthChange | ++ | February | | March | | April | | May | + + -1 6 -6 4 +

          SQL User Logins
Your table: maintable_YH8M8
MySQL version: 5.5.56-log
In this MySQL challenge, the table provided
shows all new users signing up on a specific
date in the format YYYY-MM-DD. Your query
should output the change from one month to
the next. Because the first month has no
preceding month, your output should skip
that row. Your output should look like the
following table.
Month | MonthToMonthChange |
++
| February |
| March |
| April |
| May |
+
+
-1
6
-6
4
+

SQL User Logins
Your table: maintableYH8M8
MySQL version: 5.5.56-log
In this MySQL challenge, the table provided
shows all new users signing up on a specific
date in the format YYYY-MM-DD. Your query
should output the change from one month to
the next. Because the first month has no
preceding month, your output should skip
that row. Your output should look like the
following table.
Month | MonthToMonthChange |
++
| February |
| March |
| April |
| May |
+
+
-1
6
-6
4
+

Added by Jacob A.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Samuel Goyette

Step 1

We can do this by grouping by the year and month of the signup date. Second, we need to calculate the change from one month to the next. We can do this by subtracting the count of the previous month from the count of the current month. Here is a possible SQL Show more…

Show all steps

Thanks for your feedback!

The table provided shows all new users signing up on a specific date in the format YYYY-MM-DD. Your query should output the change from one month to the next. Because the first month has no preceding month, your output should skip that row. Your output should look like the following table: SQL User Logins Your table: maintable_YH8M8 MySQL version 5.5.56-log In this MySQL challenge, the table provided shows all new users signing up on a specific date in the format YYYY-MM-DD. Your query should output the change from one month to the next. Because the first month has no preceding month, your output should skip that row. Your output should look like the following table: Month MonthToMonthChange February March 1 April 1 May 1 -1 6 -6 4