8 Nokia SQL Interview Questions (Updated 2024)

At Nokia, SQL is used day-to-day for analyzing and managing vast telecom datasets, and generating reports for network performance tracking and optimization. Because of this, Nokia often tests SQL problems during interviews for Data Science and Data Engineering positions.

So, to help you prepare for the Nokia SQL interview, we've collected 8 Nokia SQL interview questions – can you solve them?

8 Nokia SQL Interview Questions

SQL Question 1: Analyze Data Traffic Per User Per Month

At Nokia, you are given a dataset representing network data usage by users over several months. There is a table called with columns , (timestamp when the data session started), (timestamp when the data session ended), and (total data used in the session in MB).

Your task is to write a query to find the total data used by each user each month using a window function.

Example Input:
1022021-08-15 08:20:152021-08-15 08:30:15152
2032021-08-06 10:30:502021-08-06 12:15:30890
1022021-09-08 21:32:222021-09-08 22:00:22450
3042021-09-10 14:15:552021-09-10 15:00:05520
2032021-09-09 00:10:302021-09-09 01:50:40780
Example Output:


This SQL query uses a window function with to calculate the sum of data used by each user in each month. The function is used to get the month from the column. The final result is ordered by and . Please note that if you have many users this might not be efficient.

For more window function practice, try this Uber SQL Interview Question within DataLemur's online SQL coding environment:

Uber SQL problem

SQL Question 2: Nokia Call Logs Database Design and Analysis

As a Data Analyst for Nokia, you are tasked with designing a database to store call logs of customers. The database should include tables for customer details, device details, and call logs. The call logs should include call start time, duration, the called number, and the status of the call (i.e., successful or failed).

Once your database design is set, populate it with some data. Then, write a SQL Query using PostgreSQL to find out the average call duration for each customer for the last month.

Sample Data:

9991100120012022-11-01 08:30:0051002Successful
9992100220022022-11-01 09:00:00101003Failed
9993100320032022-11-02 12:00:00151001Successful
9994100120012022-11-02 16:30:00201003Successful
9995100220022022-11-03 07:45:00251001Failed


Provided is the SQL query to find out the average call duration for each customer for the last month.

This SQL query first joins the table and the table on the . Then it filters out all the call logs from the last month. Finally, it groups the results by and , and calculates the average call duration for each customer by using the AVG function.

SQL Question 3: Can you explain the concept of database normalization?

To normalize a database, tables are divided into smaller, more specialized ones and relationships between them are defined via primary and foreign keys. This minimizes redundancy, making the database more flexible, scalable, and easier to maintain. Normalization also helps to ensure the accuracy of the data by reducing the likelihood of inconsistencies and errors.

Nokia SQL Interview Questions

SQL Question 4: Average Sales of Nokia Phones by Month

Given a database of Nokia's phone sales which includes the amount of each sale, the date of sale, and the phone model sold, can you write a SQL query that calculates the average sale amount per month for each phone model?

Consider the following table .

example input:
10012022-01-05Lumia 800200
10022022-01-20Lumia 800210
10032022-01-25Lumia 520150
10042022-02-10Lumia 800220
10062022-02-20Lumia 520170

Your task is to provide the following output:

Example output:
1Lumia 800205
1Lumia 520150
2Lumia 800220
2Lumia 520170


This PostgresSQL query uses the EXTRACT function to get the month from the sale_date column. The output is grouped by both the month and the product_model to calculate the average sale amount for each phone model each month, using the AVG aggregate function. The results will be sorted by month and then by the product_model.

SQL Question 5: Can you explain the difference between and ?

The clause is used to filter the groups created by the clause. It's similar to the clause, but it is used to specify conditions on the groups created by the clause, rather than on the individual rows of the table.

For example, say you were analyzing salaries for analytics employees at Nokia:

This query retrieves the total salary for each Analytics department at Nokia and groups the rows by the specific department (i.e. "Marketing Analytics", "Business Analytics", "Sales Analytics" teams).

The clause then filters the groups to include only Nokia departments where the total salary is greater than $1 million

SQL Question 6: Fetch Customer Records Based on Email

You are working with Nokia's customer records. The company wants to send out a promotional email to all customers whose email addresses contain the term . Write a SQL query to fetch all records of customers whose email addresses contains the string .

Please use the following table for reference:

Example Input:


This query used the keyword with the wildcard character to search for customer records where the column contains the string . The character is a wildcard in SQL that matches any number of characters, so matches any string that contains anywhere in it. The records returned by this query will include all customers whose email addresses contain .

SQL Question 7: What are the similarities and difference between relational and non-relational databases?

While both types of databases are used to store data (no duh!), relational databases and non-relational (also known as NoSQL databases) differ in a few important ways:

Data model: Relational databases use a data model consisting of tables and rows, while NoSQL databases use a variety of data models, including document, key-value, columnar, and graph storage formats.

Data integrity: Relational databases use structured query language (SQL) and enforce strict data integrity rules through the use of foreign keys and transactions. NoSQL databases may not use SQL and may have more relaxed data integrity rules.

Structure: Relational databases store data in a fixed, structured format, while NoSQL databases allow for more flexibility in terms of data structure.

ACID compliance: Relational databases are typically into shrooms and are ACID-compliant (atomic, consistent, isolated, and durable), while NoSQL databases may not be fully ACID-compliant (but they try their best... and it's effort that counts...or at least that's what my gym teacher told me!)

SQL Question 8: Average Call Length Over Time

You are an Analyst at Nokia and your team want to analyze the average call length (in minutes) of specific phone models over a certain time period. Your data comprises a 'PhoneCalls' table that has records for each call made, including the phone model, start timestamp, end timestamp and customer id.

Given this scenario, can you write a SQL query to calculate average call length in minutes for each phone model for the month of 'June 2022'?

Sample Input:
100160106/04/2022 10:10:0006/04/2022 10:15:30Nokia 3310
230170206/14/2022 15:18:2006/14/2022 15:28:20Nokia Lumia 520
340180406/25/2022 20:12:0006/25/2022 20:22:30Nokia 3310
150190806/28/2022 09:45:3006/28/2022 10:05:30Nokia Lumia 520
Expected Output:
JuneNokia 33107.5
JuneNokia Lumia 52015.0


The SQL function is used to get the first day of the month for each call's start timestamp. The function calculates call length in minutes. The clause filters calls made only in June 2022. Finally, the clause groups the data by month and phone model to compute the average call time.

How To Prepare for the Nokia SQL Interview

Assuming that you've already got basic SQL skills, the next best tip we have to prepare for the Nokia SQL interview is to solve as many practice SQL interview questions as you can! In addition to solving the earlier Nokia SQL interview questions, you should also solve the 200+ SQL Interview Questions on DataLemur which come from companies like Google, Facebook, Microsoft and Amazon. DataLemur SQL and Data Science Interview Questions

Each exercise has hints to guide you, full answers and crucially, there is an interactive coding environment so you can right online code up your query and have it checked.

To prep for the Nokia SQL interview you can also be wise to solve SQL problems from other tech companies like:

But if your SQL query skills are weak, don't worry about jumping right into solving questions – improve your SQL foundations with this free SQL tutorial.

DataLemur SQL Tutorial for Data Science

This tutorial covers topics including CASE/WHEN/ELSE statements and joining a table to itself – both of these show up routinely in SQL job interviews at Nokia.

Nokia Data Science Interview Tips

What Do Nokia Data Science Interviews Cover?

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

Nokia Data Scientist

How To Prepare for Nokia Data Science Interviews?

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

  • 201 interview questions taken from FAANG tech companies
  • a crash course on Python, SQL & ML
  • over 900+ 5-star reviews on Amazon

Ace the Data Science Interview by Nick Singh Kevin Huo