SQL interview questions and answers

SEE ALSO: How to Ace the Coding Interview This document helps the reader prepare for SQL interview questions. It also includes the answers, with detailed explanations and source code. What's included in the purchase PDF file with the following: Refresher of SQL terminology, including sample SQL queries Answers to the following SQL interview questions Finding a row by using a simple equality Finding rows that contain a value as a part of a string Finding rows by using a comparison operator Finding rows that meet any of three conditions Finding rows that must meet several conditions Finding rows that are in a list of values Finding rows that have a value between two values Checking for NULL values Finding total sales and discounts for each product Calculate total revenue for each product Find the average price of each type of product and order results by average price For a specific product and category abbreviation, show the full category name using a CASE expression. Based on an item