Display the first word after the street number in a supplier's street address. For example, for the supplier "1 Pine Apple St.", the first work after the street number is "Pine". Show the supplier's street address and the first word after the street number.

Please type out the solution

SQL output

Display the first word after the street number in a supplier's street address. For example, for the supplier "1 Pine Apple St, the first word after the street number is Pine. Show the supplier's street address and the first word after the street number. 2 3 Street Address First word after street number 1 Pine Apple S Pine 123 Intemational Blvd International 33 Bejin Square Bejin 1 Electronics Road Bectronics 12 Camera 32 Camera 5