Hi Guys, I am really new to sql so i am sorry if this sounds stupid.
I have a query that shows me all the female drivers from two tables (employee and role)
SELECT role.idrole, employee.*, role.role FROM employee INNER JOIN role ON idrole=idemployee WHERE role.role="Driver" AND employee.gender="Female";
this query return 161 rows of female drivers.
now i need a table that will assign every 2 female drivers from this query to a team (example row 1 and row 2 are in team A row 3 and row 4 Team B etc)
any info or advice will be much appreciated.