use enwiki_p;
select rev_page,
EXTRACT(YEAR from rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select rev_page,
EXTRACT(YEAR from rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select rev_page,
EXTRACT(YEAR from rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select rev_page,
EXTRACT(YEAR from rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select rev_page,
EXTRACT(YEAR from rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select rev_page,
EXTRACT(YEAR from rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select rev_page,
EXTRACT(YEAR from rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select rev_page,
EXTRACT(YEAR from rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select f.year,
MAX(f.Sugar) as Sugar,
MAX(f.Salt) as... |
5 years ago |
use enwiki_p;
select f.year,
MAX(f.Sugar) as Sugar,
MAX(f.Salt) as... |
5 years ago |
use enwiki_p;
select f.year,
MAX(f.Sugar) as Sugar,
MAX(f.Salt) as... |
5 years ago |
use enwiki_p;
select f.year,
AVG(f.Sugar) as Sugar,
AVG(f.Salt) as... |
5 years ago |
use enwiki_p;
select f.year,
MAX(f.Sugar) as Sugar,
MAX(f.Salt) as... |
5 years ago |
use enwiki_p;
select f.year,
MAX(f.Sugar) as Sugar,
MAX(f.Salt) as... |
5 years ago |
use enwiki_p;
select f.year,
MAX(f.Sugar) as Sugar,
MAX(f.Salt) as... |
5 years ago |
use enwiki_p;
select f.year,
MAX(f.Sugar) as Sugar,
MAX(f.Salt) as... |
5 years ago |
use enwiki_p;
SELECT s.year,
CASE When s.ingredient_page = 'Sugar' then... |
5 years ago |
use enwiki_p;
SELECT s.year,
CASE When s.ingredient_page = 'Sugar' then... |
5 years ago |
use enwiki_p;
SELECT s.year,
CASE When s.ingredient_page = 'Sugar' then... |
5 years ago |
use enwiki_p;
SELECT s.year,
CASE When s.ingredient_page = 'Sugar' then... |
5 years ago |
use enwiki_p;
SELECT s.year,
CASE When s.ingredient_page = 'Sugar' then... |
5 years ago |
use enwiki_p;
SELECT s.year,
CASE When s.ingredient_page = 'Sugar' then... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
SELECT s.year,
CASE When s.pages = 'Sugar' then s.cnt ELSE 0... |
5 years ago |
use enwiki_p;
SELECT s.year,
CASE When s.pages = 'Sugar' then sum(s.cnt)... |
5 years ago |
use enwiki_p;
SELECT s.year,
CASE When s.pages = 'Sugar' then sum(s.cnt)... |
5 years ago |
use enwiki_p;
SELECT s.year,
s.cnt,
CASE When s.pages = 'Sugar' then... |
5 years ago |
use enwiki_p;
SELECT s.year,
s.cnt,
CASE When s.pages = 'Sugar' then... |
5 years ago |
use enwiki_p;
SELECT s.year,
s.cnt,
CASE When s.pages = 'Sugar' then s.cnt... |
5 years ago |
use enwiki_p;
SELECT s.year,
CASE When s.pages = 'Sugar' then s.cnt ELSE 0... |
5 years ago |
use enwiki_p;
SELECT s.year,
CASE When s.pages = 'Sugar' then s.cnt ELSE 0... |
5 years ago |
use enwiki_p;
SELECT s.year,
CASE When s.pages = 'Sugar' then s.cnt ELSE 0... |
5 years ago |
use enwiki_p;
SELECT s.year,
CASE When s.pages = 'Sugar' then s.cnt ELSE 0... |
5 years ago |
use enwiki_p;
SELECT s.year,
CASE When s.pages = 'Sugar' then s.cnt ELSE 0... |
5 years ago |
use enwiki_p;
SELECT s.year,
CASE When s.pages = 'Sugar' then s.cnt end as... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
SElect * from
(select EXTRACT(YEAR FROM r.rev_timestamp) as... |
5 years ago |
use enwiki_p;
SElect * from
(select EXTRACT(YEAR FROM r.rev_timestamp) as... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
SELECT s.year,
CASE When s.pages = 'Sugar' then s.cnt end as... |
5 years ago |
use enwiki_p;
SELECT s.year,
CASE When s.pages = 'Sugar' then s.cnt end as... |
5 years ago |
use enwiki_p;
SELECT s.year,
CASE When s.pages = 'Sugar' then s.cnt end as... |
5 years ago |
use enwiki_p;
SELECT s.year,
CASE When s.pages = 'Sugar' then sum(s.cnt)... |
5 years ago |
use enwiki_p;
SELECT s.year,
CASE When s.pages = 'Sugar' then sum(s.cnt)... |
5 years ago |
use enwiki_p;
SELECT * fROM (
select EXTRACT(YEAR FROM r.rev_timestamp) as... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp) as year,... |
5 years ago |
use enwiki_p;
SELECT * FROM (
select EXTRACT(YEAR FROM r.rev_timestamp) as... |
5 years ago |
use enwiki_p;
SELECT * FROM (
select EXTRACT(YEAR FROM r.rev_timestamp) as... |
5 years ago |
use enwiki_p;
SELECT * FROM (
select EXTRACT(YEAR FROM r.rev_timestamp) as... |
5 years ago |
use enwiki_p;
SELECT * FROM (
select EXTRACT(YEAR FROM r.rev_timestamp) as... |
5 years ago |
use enwiki_p;
SELECT * FROM (
select EXTRACT(YEAR FROM r.rev_timestamp) as... |
5 years ago |
use enwiki_p;
SELECT * FROM (
select EXTRACT(YEAR FROM r.rev_timestamp) as... |
5 years ago |
use enwiki_p;
SELECT * FROM (
select EXTRACT(YEAR FROM r.rev_timestamp),... |
5 years ago |
use enwiki_p;
SELECT * FROM (
select EXTRACT(YEAR FROM r.rev_timestamp),... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp), count(r.rev_page)... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp), count(r.rev_page)... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp), count(r.rev_page)... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp), count(r.rev_page)... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp), count(r.rev_page)... |
5 years ago |
use enwiki_p;
SELECT * FROM
(
select EXTRACT(YEAR FROM r.rev_timestamp),... |
5 years ago |
use enwiki_p;
SELECT * FROM
(
select EXTRACT(YEAR FROM r.rev_timestamp),... |
5 years ago |
use enwiki_p;
SELECT * FROM
(
select EXTRACT(YEAR FROM r.rev_timestamp),... |
5 years ago |
use enwiki_p;
SELECT * FROM
(
select EXTRACT(YEAR FROM r.rev_timestamp),... |
5 years ago |
use enwiki_p;
SELECT * FROM
(
select EXTRACT(YEAR FROM r.rev_timestamp),... |
5 years ago |
use enwiki_p;
SELECT * FROM
(
select EXTRACT(YEAR FROM r.rev_timestamp),... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp),... |
5 years ago |