May was a big month for new releases from Linux Academy! Take a look at what our team built recently in our blog. You can access the newest releases from our blog.
SELECT DATEPART(WEEKDAY,DATE) AS DOW, DATEPART(HOUR,DATE) AS HOD, COUNT(TableA.ID) AS ALLCOUNT, COUNT(CASE TableA.TYPE='YES' THEN 1 ELSE NULL END) AS COUNTTYPEYESA, COUNT(CASE TableB.TYPE='YES' THEN 1 ELSE NULL END) AS COUNTTYPEYESB, SUM(CASE WHEN TableB.TYPE='YES' AND TableC.TYPE='YES') AS COUNTTYPEYESBC, FROM TableA, TableB, TableC WHERE TableA.ID = TableB.ID AND TableB.ID = TableC.ID GROUP BY DATEPART(HOUR,DATE),DATEPART(WEEKDAY,DATE) ORDER BY DOW, HOD
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.