Table: single_info
Columns: title
type
artist
label
standard_number
release_date

Question: Which Artist has the Label of Columbia and the Standard number of COCC-72073?
SQL: SELECT "artist" FROM single_info WHERE "label" = 'columbia' AND "standard_number" = 'cocc-72073'

Question: What Type has the Artist of Hiroyuki Takami?
SQL: SELECT "type" FROM single_info WHERE "artist" = 'hiroyuki takami'

Question: What Title has the Label of Columbia and Standard number of CODC-8760?
SQL: SELECT "title" FROM single_info WHERE "label" = 'columbia' AND "standard_number" = 'codc-8760'