Among the flights with air carrier named Republic Airline, how many of the flights have departure delay of 30 minutes and above?
Republic Airline refers to Description which contains 'Republic Airline'; departure delay of 30 minutes and above refers to DEP_DELAY > 30;
SELECT COUNT(*) FROM `Air Carriers` AS T1 INNER JOIN Airlines AS T2 ON T1.Code = T2.OP_CARRIER_AIRLINE_ID WHERE T1.Description LIKE '%Republic Airline%' AND T2.DEP_DELAY > 30
database name:db_id airline
Air Carriers table Air Carriers Cols: Code dtype integer, Description dtype text, 
Airports table Airports Cols: Code dtype text, Description dtype text, 
Airlines table Airlines Cols: flight date dtype text, operator carrier airline id dtype integer, tail number dtype text, operator carrier flight number dtype integer, origin airport id dtype integer, origin airport sequence id dtype integer, origin city market id dtype integer, ORIGIN dtype text, destination airport id dtype integer, destination airport sequence id dtype integer, destination city market id dtype integer, destination dtype text, scheduled local departure time dtype integer, departure time dtype integer, Departure delay dtype integer, departure delay new dtype integer, arrival time dtype integer, arrival delay dtype integer, arrival delay new dtype integer, CANCELLED dtype integer, cancellation code dtype text, scheduled elapsed time dtype integer, actual elapsed time dtype integer, carrier delay dtype integer, weather delay dtype integer, National Aviavtion System delay dtype integer, security delay dtype integer, late aircraft delay dtype integer, 
