10 Zebra Technologies SQL Interview Questions (Updated 2024)

Updated on

March 1, 2024

At Zebra Technologies, SQL is used quite frequently for analyzing logistics data, and for analyzing RFID data collected from the factory floor. That's why Zebra Technologies LOVES to ask SQL questions in interviews for Data Science, Data Engineering and Data Analytics jobs.

To help you study for the Zebra Technologies SQL interview, we've curated 10 Zebra Technologies SQL interview questions – can you solve them?

10 Zebra Technologies SQL Interview Questions

SQL Question 1: Analyzing Zebra Technologies Power Customers

As a data analyst at Zebra Technologies, you've been given access to the company's database. This database hosts several tables related to our customers' data including their purchasing habits, the products they buy, and the frequency of their purchases.

In this context, a power customer for Zebra Technologies is a customer who purchases above $500 worth of goods monthly. Your task is to create a SQL query that can extract data from Zebra Technologies' customer database to identify these power customers.

Here's our raw data:

Example Input:
100120001/08/2022 00:00:005001300
100212301/08/2022 00:00:006002600
100320002/10/2022 00:00:005002300
100434501/08/2022 00:00:002345700
100520003/26/2022 00:00:001701150
Example Input:


Please write a query in PostgreSQL to solve the problem.

Here is an example of a SQL query that could solve this task:

This PostgreSQL query will return the first name and last name of each power customer for the current month. The condition ensures that only purchases made in the current month are accounted for in the query. The condition filters out any customers who haven't made a total purchase amount of more than $500 during the current month.

To solve a related super-user data analysis question on DataLemur's free online SQL coding environment, try this Microsoft Teams Power User SQL Interview Question: Microsoft SQL Interview Question: Teams Super User

SQL Question 2: Average Sales Per Month Per Product

Zebra Technologies is a company focusing on barcode, RFID, and enterprise printing. They also provide supplies such as barcode labels and ribbons, RFID tags, cards and receipt paper, and Synthetic labels.

Suppose you are given a sales data of Zebra technology products, with each row representing a product sold to a client. Your task is to write a SQL query that calculates the average sales per month for each product.

Example Input:
10112306/08/2022 00:00:00500013
10226506/12/2022 00:00:00698522
10336206/19/2022 00:00:00500011
10419207/26/2022 00:00:00698525
10598107/05/2022 00:00:00698523
Example Output:


This SQL query makes use of window functions to compute the average sales per month for every product. is used to group the sales data by month, and is used to further divide the data by product. Then, the function is used with the clause to carry out the computation. This allows the calculation to focus on each subset of data defined by the clause. Hence, it produces the average sales per month for each product.

To practice another window function question on DataLemur's free online SQL coding environment, solve this Amazon SQL Interview Question: Amazon Window Function SQL Interview Problem

SQL Question 3: Can you provide a comparison of cross join and natural join?

Imagine you are organizing a party and have two database tables: one table of people you want to invite and another list of food items you want to serve.

A cross join would be like inviting every person on your list to the party and serving them every food item on the menu, regardless of whether they like the food or not. So, if you had 10 people on your invite list and 5 food items on the menu, you would generate all 50 different combinations of people and food (10 x 5 = 50).

On the other hand, a natural join would be like inviting only the people who like the food items on the menu (based on doing a inner/left/right/outer JOIN on a common key like ).

Zebra Technologies SQL Interview Questions

SQL Question 4: Filter Customer Records from Zebra Technologies Database

Zebra Technologies wants to identify customers who have purchased a specific "Mobile Computer" product and live in a certain region (for example, "North America"). The goal is to run a promotional campaign targeting these specific customers.

Write a query to filter customers who have purchased the Mobile Computer and reside in North America.

Given the tables below:

Example Input:
1001JohnDoejohndoe@example.comNorth America
1004LisaWhitelisawhite@example.comNorth America
1005TomBlacktomblack@example.comSouth America
Example Input:
56781001Mobile Computer2022-08-26
91011002Thermal Printer2022-08-27
11211003Barcode Scanner2022-08-28
31411004Mobile Computer2022-08-29
51611005Mobile Computer2022-08-30


You can solve this question with a simple SQL SELECT statement combined with a WHERE clause that uses the AND operator to include multiple conditions.

This query first joins the customer and orders table based on the customer_id, which is the common field. It then filters the customers based on the region and product they purchased. The resulting output will display the customer_id, first_name, last_name, and email of the customers who live in North America and have purchased a Mobile Computer.

SQL Question 5: What are stored procedures, and why are they useful?

Stored procedures in SQL are like recipes in a cookbook. Just like a recipe tells you the ingredients and instructions for making a particular dish, a stored procedure tells the DBMS the logic/statements needed to perform a specific task. Just like you can use a recipe to make the same dish over and over again, you can use a stored procedure to repeat the same task multiple times with different input parameters (which is why stored procedures are so damn useful!).

Say you were a Data Analyst working on a HR analytics project. A common sub-task you might have to do is calculate the average salary for a given department at Zebra Technologies, which would be perfect for a stored procedure:

To call this stored procedure and find the average salary for the Data Science department you'd execute a query like this:

SQL Question 6: Calculate the Average Equipment Usage Time

Zebra Technologies provides a variety of hardware such as printers, scanners, mobile computers, etc. As an SQL developer, your task is to find the average usage time of the equipment used by employees for a period of a week. Assume you have access to an 'equipment_usage' table with 'user_id', 'equipment_id', 'usage_start_time' and 'usage_end_time' columns.

Example Input:
1101012022-08-02 08:00:002022-08-02 10:00:00
2111012022-08-02 11:00:002022-08-02 14:00:00
3101042022-08-03 09:00:002022-08-03 15:00:00
4111032022-08-03 10:00:002022-08-03 11:30:00
5101022022-08-04 08:00:002022-08-04 12:00:00

You should write an SQL query that gives the average usage time per equipment for each user in hours.


This query works by first calculating the usage time for each row by subtracting the 'usage_start_time' from the 'usage_end_time'. It then uses the 'EXTRACT' function to convert the time interval to seconds ('EPOCH'), which is then divided by 3600 to convert it to hours. The 'AVG' function is then used to calculate the average time usage per equipment for each user.

To practice a very similar question try this interactive Amazon Server Utilization Time Question which is similar for calculating total usage time.

SQL Question 7: What does the constraint do?

A UNIQUE constraint ensures that all values in a column are different. It is often used in conjunction with other constraints, such as NOT NULL, to ensure that the data meets certain conditions.

For example, if you had Zebra Technologies employee data stored in a database, here's some constraints you'd use:

In the Zebra Technologies employee example, the UNIQUE constraint is applied to the "email" field to ensure that each employee has a unique email address. This helps to ensure the integrity of the data in the database and prevents errors that could occur if two employees had the same email address.

SQL Question 8: Analyzing Sales of Zebra Technologies

Zebra Technologies is a company that sells barcode readers, printers, RFID tags, and other related inventory tracking systems. As a data analyst for Zebra Technologies, you are tasked to analyze the sales for their products.

For each product category, find out the total units sold, maximum units sold in a single sale and the average number of units sold per sale.

Consider the following tables:

Example Input:
Example Input:
P2001Barcode Readers
P3001RFID Tags


Using SQL, the following query will help us solve the problem:

This query will join the 'sales' and 'products' tables on 'product_id', and group the results by 'product_category'. For each category, it will compute the total, maximum and average units sold. Using these analytics, Zebra Technologies can gain insights into their sales performance across different product categories.

SQL Question 9: Finding Customers with Specific Email Domains

Zebra Technologies wants to send out a marketing email to all of their customers that have email addresses with the domain . As a SQL developer for Zebra, your job is to fetch all records of customers whose email suits this pattern.

Assume there's a table with fields , , , and in your database.

Example Input:


This query would return all records from the database where the field ends with , thus allowing Zebra Technologies to target these specific customers for their marketing email.

Example Output:

SQL Question 10: What are the similarities and differences between the and functions?

Both the and window functions are used to access a row at a specific offset from the current row.

However, the function retrieves a value from a row that follows the current row, whereas the function retrieves a value from a row that precedes the current row.

Often, the offset for both functions is 1, which gives access to the immediately following/preceding row. Here's a SQL query example:

Zebra Technologies SQL Interview Tips

The best way to prepare for a SQL interview, besides making sure you have strong SQL fundamentals, is to practice a ton of real SQL questions that were asked in recent job interviews. Beyond just solving the earlier Zebra Technologies SQL interview questions, you should also solve the 200+ SQL Interview Questions on DataLemur which come from companies like Microsoft, Google, and Facebook. DataLemur Question Bank

Each DataLemur SQL question has multiple hints, fully explained answers along with a discussion board to see how others solved it and most importantly, there is an interactive SQL code editor so you can easily right in the browser your SQL query and have it executed.

To prep for the Zebra Technologies SQL interview it is also a great idea to practice interview questions from other tech companies like:

However, if your SQL query skills are weak, forget about diving straight into solving questions – strengthen your SQL foundations with this interactive SQL tutorial.

SQL tutorial for Data Scientists & Analysts

This tutorial covers SQL concepts such as joining a table to itself and RANK() window functions – both of these pop up frequently during Zebra Technologies interviews.

Zebra Technologies Data Science Interview Tips

What Do Zebra Technologies Data Science Interviews Cover?

Besides SQL interview questions, the other topics to prepare for the Zebra Technologies Data Science Interview are:

  • Statistics and Probability Questions
  • Python Pandas or R Coding Questions
  • Product Analytics Questions
  • ML Interview Questions
  • Behavioral & Resume-Based Questions

Zebra Technologies Data Scientist

How To Prepare for Zebra Technologies Data Science Interviews?

To prepare for Zebra Technologies Data Science interviews read the book Ace the Data Science Interview because it's got:

  • 201 interview questions sourced from Facebook, Google, & Amazon
  • a crash course covering Python, SQL & ML
  • over 900+ reviews on Amazon & 4.5-star rating

Ace the Data Science Interview by Nick Singh Kevin Huo