I am looking for a SQL statement to view tickets open only and or unassigned.

not in the SD part of Kaseya but the raw install of kaseya

can anyone help please as I am not a SQL