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*
This video will show you what you can and can't do when using the grouping clause.
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.