SQL

Examples

Most X of the Day

SELECT X, count(X)
FROM some_table
WHERE some_condition AND date_column BETWEEN '2016-04-01 00:00:00' AND '2016-04-02 00:00:00'
GROUP BY X
ORDER BY COUNT(X) DESC

Top X of the day (Historical)

SELECT date, X, MAX(count)
FROM (SELECT DATE(date_column) as date, X, COUNT(X) as count
      FROM some_table
      WHERE some_condition
      GROUP BY DATE(date_column), symbol
      ORDER BY DATE(date_column) DESC, COUNT(X) DESC
) AS whatever
GROUP BY date
ORDER BY date DESC, count DESC

Rows per date

SELECT DISTINCT(DATE(date_column)), count(date_column)
FROM some_table
GROUP BY DATE(date_column)

Distinct values per group per day + multiple filters per column + since date

SELECT DATE(date_column), grouped_column, COUNT(distinct distinct_column), count(*)
FROM table
WHERE some_column = "value"
AND (other_column LIKE "%asdf%" OR other_column LIKE "%qwer%")
AND date_column > "1984-01-01 00:00:00"
GROUP BY DATE(date_column), grouped_column
ORDER BY DATE(date_column) DESC