如何在CASE中进行JOIN？或者使用UNION？ （SQL）

I currently have two different queries for a module in an application I just started to support (first programming job). The first query selects all cars where the Engine is in (9,10,11,12,13). The second one gets all cars where the Engine is in (4,44). They both work fine, the only problem is that when they are placed in the same table on the JSP, they don't use the same filter. So basically, all the data for the first query will always come first, and the data for the second query will always come second. If you sort alphabetically, it will sort all of the data from the first query, A-Z, then the data from the second query, A-Z, so you would see something like:I currently have two different queries for a mo