SQLize | PHPize | SQLtest

SELECT DISTINCT a.name, b.name FROM stops a JOIN route z ON a.id = z.stop JOIN route y ON y.num = z.num SELECT name FROM movie JOIN casting ON movie.id = actorid JOIN actor ON actor.id = movieid WHERE director = 351 SELECT name FROM movie JOIN casting ON movie.id = movieid JOIN actor ON actor.id = actorid WHERE ord = 1 AND director = 351 SELECT name, COUNT(movieid) FROM actor JOIN casting ON actorid = actor.id WHERE name IN 'John %' GROUP BY name ORDER BY 2 SELECT * FROM actor JOIN casting BY actor.id = actorid JOIN movie BY movie.id = movieid SELECT title, yr FROM movie, casting, actor WHERE name = 'Robert De Niro' AND movieid = movie.id AND actorid = actor.id AND ord = 3 SELECT SUM(population) FROM bbc WHERE region = 'Europe' SELECT COUNT(name) FROM bbc WHERE population < 150000 SELECT name FROM bbc WHERE population < 150000 AVG(), COUNT(), MAX(), MIN(), SUM() SELECT AVG(population) FROM bbc WHERE name IN ('Poland', 'Germany', 'Denmark' SELECT region, SUM(population)/SUM(area) AS density FROM bbc HAVING region SELECT name, population/area AS density FROM bbc WHERE population > (SELECT MAX(population) FROM bbc) SELECT name, population/area AS density FROM bbc WHERE population > SELECT name, population/area AS density FROM bbc WHERE population = (SELECT MAX(population) FROM bbc) (SELECT MAX(population) FROM bbc) SELECT name, density AS population/area FROM bbc WHERE population = (SELECT MAX(population) FROM bbc) SELECT AVG(population) FROM bbc WHERE name IN ('Poland', 'Germany', 'Denmark' SELECT COUNT(name) FROM bbc WHERE population < 150000 SELECT COUNT(population < 150000) FROM bbc SELECT name FROM bbc WHERE population < 150000 SELECT winner FROM nobel WHERE winner LIKE 'C%' AND winner LIKE '%n SELECT COUNT(subject) FROM nobel WHERE subject = 'Chemistry' AND yr BETWEEN (1950, 1960) eteam JOIN game ON (id=tea m1) matchid, teamid, player, gtime, id, teamname, coac SELECT player, teamid, COUNT(*) FROM game JOIN goal ON matchid = id WHERE (team1 = "GRE") AND teamid != 'GRE' GROUP BY player, teamid