In this post, we will solve **OLAP Operation Types HackerRank Solution**. This problem **(OLAP Operation Types)** is a part of **HackerRank Databases** series.

**Task**

Consider a fact table DataPoints(D1,D2,D3,x), and the following three queries:

`Q1: Select D1,D2,D3,Sum(x) From DataPoints Group By D1,D2,D3`

`Q2: Select D1,D2,D3,Sum(x) From DataPoints Group By D1,D2,D3 WITH CUBE`

`Q3: Select D1,D2,D3,Sum(x) From DataPoints Group By D1,D2,D3 WITH ROLLUP`

Suppose attributes D1, D2, and D3 have n1, n2, and n3 different values respectively, and assume that each possible combination of values appears at least once in the table DataPoints. The number of tuples in the result of each of the three queries above can be specified as an arithmetic formula involving n1, n2, and n3. Pick the one tuple (a,b,c,d,e,f) in the list below such that when n1=a, n2=b, and n3=c, then the result sizes of queries Q1, Q2, and Q3 are d, e, and f respectively.

**Solution – OLAP Operation Types – HackerRank Solution**

**Correct Answer – (4, 7, 3, 84, 160, 117)**

**Note:** This problem **(OLAP Operation Types)** is generated by **HackerRank** but the solution is provided by **CodingBroz**. This tutorial is only for **Educational** and **Learning** purpose.

Aditi YadavI need explaination of the solution in case you can provide.