A database table called “Listing” exists with the following fields:
ID (int, pk),
Name (varchar),
IsPromoted (bit).
Write a SELECT statement that accepts @Query as input, and returns all entries from this table with a partial match on this. Promoted listings, if they exist in the results, should be boosted so that they appear in every odd result, starting with position #1.