Table: rail_segment_info
Columns: segment_description
date_opened
line_s
endpoints
of_new_stations
length_miles

Question: How many news stations opened on the date of June 24, 2000?
SQL: SELECT "of_new_stations" FROM rail_segment_info WHERE "date_opened" = 'June 24, 2000'

Question: What is the length  (miles) when pico to 7th st/metro center are the endpoints?
SQL: SELECT "length_miles" FROM rail_segment_info WHERE "endpoints" = 'Pico to 7th St/Metro Center'

Question: How many lines have the segment description of red line mos-2 west?
SQL: SELECT "line_s" FROM rail_segment_info WHERE "segment_description" = 'Red Line MOS-2 West'

Question: What is the lenth (miles) of endpoints westlake/macarthur park to wilshire/western?
SQL: SELECT "length_miles" FROM rail_segment_info WHERE "endpoints" = 'Westlake/MacArthur Park to Wilshire/Western'

Question: What date of segment description red line mos-2 north open?
SQL: SELECT "date_opened" FROM rail_segment_info WHERE "segment_description" = 'Red Line MOS-2 North'

Question: How many new stations have a lenght (miles) of 6.0?
SQL: SELECT COUNT("of_new_stations") FROM rail_segment_info WHERE "length_miles" = '6.0'