Querying with prefSQL



SELECT c.Title AS Name, c.Price, c.Mileage, co.Name AS Color, b.Name AS Body FROM Cars AS c LEFT OUTER JOIN Colors co ON c.Color_Id = co.Id LEFT OUTER JOIN Bodies b ON c.Body_Id = b.Id SKYLINE OF c.Price LOW, c.Mileage LOW

Preference Queries

Results 9

Sql Execution Time: 171.8792 ms

1HONDA Stream 2.0i ES (Sport)1200200grayminivan
2FORD KA 1.3500105000blackcompact car
3FORD KA 1.360092000bluecompact car
4FORD Mondeo 2.0i Trend300174000greenlimousine
5CITROEN Xsara 1.8i 16V SX400132145redlimousine
6SUZUKI Swift 1.3 GLX110062000greencompact car
7FORD KA2 1.370082000redcompact car
8DAEWOO Kalos 1.4 16V SX32000bluecompact car
9DAIHATSU Cuore Mio90070000bluecompact car