L0 Search Keyword References

Created by Rahul Pattamatta, Modified on Wed, 28 Feb at 4:36 AM by Rahul Pattamatta

Tailor your search with calculation-based keywords like 'sum', 'average', and 'max', ideal for quantitative analysis. Click here for more.

SQL Function	Keyword	Example
AVG	Average	1. What's the average sales amount? 2. What's the average call duration?
	Mean	1. What's the mean temperature in July? 2. What's the mean test score?
	Medium	1. What's the medium product weight? 2. What's the medium salary range?
	General	1. What's the general satisfaction rating? 2. What's the general crop yield?
SUM	Much	1. How much is the combined weight of all shipments? 2. How much is the total investment in new equipment?
	Total	1. What is the total count of products sold this year? 2. What is the total amount of customer feedback received?
	Entire	1. What is the entire expenditure on marketing this year? 2. What is the entire amount of rainfall received during the monsoon?
	Overall Amount	1. What is the overall amount spent on research? 2. What is the overall amount of bonuses distributed to employees?
COUNT DISTINCT	Different Types	1. How many different types of smartphones are in the store? 2. What are the different types of memberships available?
	How Many Distinct	1. How many distinct cultures are represented in the team? 2. How many distinct skill sets are in the employee pool?
	Number of Unique	1. What is the number of unique visitors to the park? 2. How many unique solutions were proposed in the brainstorming session?
	Many of Each	1. How many of each product type were sold? 2. What is the count of many of each species in the habitat?
COUNT	How Many	1. How many times has the most popular service been used? 2. How many products are in the current catalog?
	Number of	1. What is the number of new sign-ups this week? 2. How many orders were placed this weekend?
	Quantity	1. What is the total quantity of raw materials used? 2. How much total product was shipped this quarter?
	How Much	1. How much of the budget has been spent so far? 2. How much time is spent on average in meetings?
MAX	Maximum	1. What is the maximum temperature recorded this year? 2. What is the maximum sales volume achieved by a single product?
	Top	1. Which movie had the top box office collection? 2. What is the top altitude reached by the climbers?
	Best	1. Which athlete scored the best time in the marathon? 2. What is the best grade achieved in the class?
	Highest	1. Which department had the highest revenue last quarter? 2. What is the highest score achieved in the game?
MIN	Minimum	1. What is the minimum temperature recorded this year? 2. What is the minimum number of steps taken by any user in a day?
	Bottom	1. What is the bottom price for the stock? 2. What was the bottom count of attendees at the event?
	Lowest	1. Which department had the lowest revenue last quarter? 2. What is the lowest score achieved in the game?
	Smallest	1. What is the smallest size available for this product? 2. What was the smallest distance traveled by any shipment?

Dimension Keywords (Text):

Enhance searches with text-based keywords to identify specific words or phrases, such as product names or categories. Click here for more.

SQL Function	Keyword	Example
DISTINCT	Unique	1. List all unique customer names from the database. 2. Show unique product IDs from recent sales.
	Different	1. Identify different payment methods used 2. Display different shipping countries.
	Diverse	1. Identify diverse age groups in customer data. 2. Extract diverse genres in media library.
	Exclusive	1. Show exclusive membership types. 2. List exclusive event attendees.

Filter Keywords (Comparative, Date, Location):

Refine your data analysis using comparative, date, and location-based keywords. These are perfect for setting time frames, comparing metrics, and focusing on geographical areas. Click here for more.

SQL Function	Keyword	Example
=	Equals	1. Find records where the quantity equals 10. 2. Display employees whose tenure equals 5 years.
	Is the same as	1. List products whose price is the same as $20. 2. Identify days when the output is the same as the target.
<>	Does not equal	1. Find records where the quantity does not equal 10. 2. Display employees whose tenure does not equal 5 years.
	Is not the same as	1. List products whose price is not the same as $20. 2. Identify days when the output is not the same as the target.
LIKE	Similar to	1. Find names similar to 'John'. 2. Display products similar to 'milk'.
	Like	1. Search for emails like '%@gmail.com'. 2. List titles like 'Mr.%'.
NOT LIKE	Not starting with	1. Find cities not starting with 'New'. 2. List emails not starting with 'info'.
	Not ending with	1. Search for usernames not ending with 'smith'. 2. Display products not ending with 'free'.
IN	Included in	1. List countries included in 'USA', 'UK', 'Canada'. 2. Show orders included in 'Completed', 'Shipped', 'Processing'.
	Part of	1. Display items part of 'Summer Collection', 'Winter Sale'. 2. Locate accounts part of 'Premium', 'Standard', 'Basic'.
NOT IN	Not among	1. Find products not among 'electronics', 'furniture', 'clothing'. 2. Identify employees not among 'Sales', 'Marketing', 'IT'.
	Not included in	1. List countries not included in 'USA', 'UK', 'Canada'. 2. Show orders not included in 'Completed', 'Shipped', 'Processing'.
>	More than	1. Find employees with salaries more than $50,000. 2. Identify products with more than 100 units in stock.
	Exceeding	1. List days exceeding 24 hours of usage. 2. Show transactions exceeding $1,000 in value.
<	Less than	1. Find products with a price less than $100. 2. Identify employees younger than 30 years.
	Smaller than	1. List files smaller than 2MB. 2. Show areas smaller than 500 square feet.