Write SQL query to solve given problem: Give the name of the brands that brewed their first drink between 1996 and 2000 in the descending order of the date brewed.. Keep the solution inside sql tag ```sql [SQL-Query] ```
SELECT BrandName FROM rootbeerbrand WHERE FirstBrewedYear BETWEEN '1996' AND '2000' ORDER BY FirstBrewedYear DESC