Warning! The page was not fully loaded, probably because of a network issue. It could be that not all functionalities work as expected. Please try reloading the page.

Drop links or images here to add them to the editor.

Database schema

Geef het aantal observaties per plot_type, species en genus van alle dieren van het mannelijk geslacht. De resulterende tabel moet de kolommen ‘aantal’, ‘species’, ‘genus’ en ‘plot_type’ bevatten.

Hint

SELECT f(...) AS ..., ... FROM ... INNER/LEFT/RIGHT/FULL JOIN ... ON ... INNER/LEFT/RIGHT/FULL JOIN ... ON ... WHERE ... GROUP BY ... ;