I need some help as i dont know where to start...
I have a table with 3 columns. Car ID, Car Make, Car price
I am needing an alphabet, to be returned, with car make that can be a reference point for its ID and Price
Select car_make from table_cars where car_make like 'A%'
For every car found, a dynamic alphabet reference is assigned. Alpha Romeo is returned as Alpha Romeo (A), Audi is returned is Audi (B) and Acura is returned as Acura (C)
Now for every car found, i would like to be able to get the price and reference it by the alphabet used for that car. Such that the results will be