For individual elements, the bulk of them are solids. H2, N2, O2, F2, Cl2 and the whole of Group VIII are gases. Only Br2 and Hg are liquids.
Ionic compounds have a high melting and boiling point so assume that they are solids. Ionic compounds are those containing metal cations and anions (e.g. NaCl, MgCl2, KI) or metal cations and polyatomic ions (e.g. CaCO3, AgNO3, Fe2(SO4)3).
Covalent compounds can be solid, liquid or gas. Small molecules that contain H and other light atoms are usually gases, e.g. HCl, SO2, CO2 and CH4. For a class of organic compound, the state usually changes from gas to liquid to solid, or liquid to solid, with increasing number of carbon atoms. For alkanes for example, CH4 to C4H10 are gaseous, C5H12 to C17H36 are liquids, and C18H38 and bigger are solids.
Aqueous just means dissolved in water and usually refers to solutions of ionic solids.