Create index on column 'fruit' of the fruitsforsale table:

CREATE INDEX idx1 ON fruitsforsale(fruit);

Create index on two columns of the fruitsforsale table:

CREATE INDEX Idx3 ON FruitsForSale(fruit, state);

Select with output ordered by specific column:

SELECT * FROM fruitsforsale ORDER BY fruit;

Select of specific rows with output ordered by specific column:

SELECT price FROM fruitforsale WHERE fruit='Orange' ORDER BY state