Loading Question...
ME
Mosquito Species Database Query - Adobe Hackathon 2026
MediumMed•156 views
Given a database of mosquito species, write a query to retrieve the species name, scientific name, habitat, active time, species rank, and species count for each species.
Constraints:
- The database consists of two tables: MosquitoSpecies and Output.
- The MosquitoSpecies table has the following columns: species_name, scientific_name, disease_vector, active_time, and habitat.
- The Output table has the following columns: species_name, scientific_name, habitat, active_time, species_rank, and species_count.
- The active_time column can be either 'Night' or 'Day'.
- The species_rank and species_count columns are integers.