Table: dorado_group
Columns: name
type
r_a_j2000
dec_j2000
redshift_km_s
apparent_magnitude

Question: Which Name has Apparent Magnitude smaller than 11.4, and R.A. (J2000) of 04h17m35.8s?
SQL: SELECT "name" FROM dorado_group WHERE "apparent_magnitude" < 11.4 AND "r_a_j2000" = '04h17m35.8s'

Question: Which R.A. (J2000) has a Name of ngc 1543?
SQL: SELECT "r_a_j2000" FROM dorado_group WHERE "name" = 'ngc 1543'

Question: Which Dec. (J2000) has a Redshift (km/ s) of 1331 ± 3?
SQL: SELECT "dec_j2000" FROM dorado_group WHERE "redshift_km_s" = '1331 ± 3'

Question: Which R.A. (J2000) has a Name of ngc 1515?
SQL: SELECT "r_a_j2000" FROM dorado_group WHERE "name" = 'ngc 1515'

Question: Which R.A. (J2000) has Apparent Magnitude of 11.7, and Dec. (J2000) of °07′06″?
SQL: SELECT "r_a_j2000" FROM dorado_group WHERE "apparent_magnitude" = 11.7 AND "dec_j2000" = '°07′06″'