The default search term operator is AND
You can use brackets, AND OR and NOT to improve your search. For example: C# AND NOT ( VB or SQL )
A query of a single * will return everything, filtered by any filters.
Search by Author: author:"author name"
Filter by tag: tag:C# or tag:(C++ or Java)
Wildcard search use: "?" or "*" eg. gr?d or gr*
The GROUP BY clause allows you to consolidate your data by one or more criteria. This video will show you how to do this.
This video from our "SQL Database for Beginners" series will introduce you to grouping your data and how to use the GROUP BY clause. You will also be shown the HAVING clause and what you should and should not do while grouping.