Hello, Before I dive into https://www.sqlitetutorial.net, I'd like to check with experienced users whether SQLite is up to the task, or I should maybe run multiple queries possibly with some help from PHP.
Using the following tables, I need to find how employees from each city come to work. ====== Employees table: EMPLOYEE_ID | CITY_ID Cities table: CITY_ID | CITY_TXT Mode table: MODE_ID | MODE_TXT This is the type of output I need to get ultimately: CITY | WALKING | CYCLING | PUBLIC TRANSIT | CAR | OTHER City1 | 15% | 5% | 50% [ 25% | 5% Do you think it can it be done in a single query using a mixture of COUNT(), SUM(), GROUP BY, HAVING etc., or will I have to split the task into a few independent queries? Thank you. -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
