covid-19-uk

Custom SQL query returning 9 rows (hide)

select Date, Country, AreaCode, Area, TotalCases from cases where "Country" = :p0 and date("Date") = :p1 and (Area > :p6 or (Area = :p6 and ((Date > :p2) or (Date = :p2 and Country > :p3) or (Date = :p2 and Country = :p3 and AreaCode > :p4) or (Date = :p2 and Country = :p3 and AreaCode = :p4 and Area > :p5)))) order by Area, Date, Country, AreaCode, Area limit 101

Query parameters

p0

p1

p6

p2

p3

p4

p5