Ugam Solution
Upwork Interview Questions and Answers
Q1. what tool yoou have worked on before
I have worked on Tableau for data visualization and analysis.
Created interactive dashboards to visualize sales data
Used Tableau to analyze customer behavior patterns
Integrated Tableau with SQL databases for real-time reporting
Q2. Difference between HAVING AND WHERE
HAVING is used with GROUP BY to filter groups, WHERE is used to filter rows before grouping.
HAVING is used with GROUP BY to filter groups based on aggregate functions
WHERE is used to filter rows before grouping
HAVING is applied after the GROUP BY clause, WHERE is applied before
Q3. Palindrom program by using any language
A palindrome program checks if a given string reads the same forwards and backwards.
Create a function that takes a string as input
Remove any spaces and punctuation from the string
Reverse the string and compare it to the original string to check for palindrome
Q4. what is market research
Market research is the process of gathering, analyzing, and interpreting information about a market, including customers, competitors, and industry trends.
Involves collecting data on customer preferences, buying habits, and market trends
Helps businesses make informed decisions about product development, pricing, and marketing strategies
Can include surveys, focus groups, and data analysis
Examples: conducting a survey to understand customer satisfaction levels, analyzing compet...read more
Q5. 2nd highest salary using SQL.
Use SQL query with ORDER BY and LIMIT to find 2nd highest salary.
Use ORDER BY clause to sort salaries in descending order.
Use LIMIT 1,1 to skip the highest salary and fetch the second highest salary.
Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1;
Q6. Greater number from list
The greater number from a list is the highest number present in the list.
Compare each number in the list to find the highest one
If there are multiple highest numbers, all of them are considered as the greater number
For example, in the list [5, 10, 3, 10], the greater number is 10
Interview Process at Upwork
Top Analyst Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month