The provision to run multiple queries simultaneously is not available in Athena yet. So you can try the following command once you decide the Database you want to drop but doing this will delete the tables under that database. Do not use this if you want to drop only particular tables.
DROP DATABASE db_name CASCADE;
If you want to delete only a few tables, then run those queries one by one and get i