Awign Enterprises Computer Typist Interview Questions and Answers

Q1. How would you use your skill for sales
Add your answer

Q1. SQL question difference between having and where
Ans. 
HAVING is used with GROUP BY to filter groups, WHERE is used to filter rows
• HAVING is used with GROUP BY to filter groups based on aggregate functions

• WHERE is used to filter rows based on conditions

• HAVING is applied after GROUP BY, WHERE is applied before GROUP BY

• Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;

• Example: SELECT * FROM employees WHERE department = 'S
Answered by AI
Add your answer

Quant, LR, puzzles, cat based level 2 questions

Q1. Difference between tuple nd list
Ans. 
Tuple is immutable and ordered, while list is mutable and ordered in Python.
• Tuple is created using parentheses () while list is created using square brackets []

• Tuple elements cannot be changed once assigned, while list elements can be modified

• Tuple is faster than list for iteration and accessing elements

• Example: tuple = (1, 2, 3) and list = [1, 2, 3]
Answered by AI
Add your answer
Q2. How will you cut a cake into 8 equal pieces by 3 cuts
Add your answer

Q1. Walk me through ur cv
Ans. 
I have a strong background in data analysis with experience in various industries.
• Bachelor's degree in Statistics with a focus on data analysis

• Proficient in SQL, Python, and data visualization tools like Tableau

• Experience working with large datasets and conducting statistical analysis

• Completed internships at XYZ Company and ABC Organization

• Presented findings at industry conferences
Answered by AI
Add your answer
Q2. What have learnt from this experience?
Ans. 
I have learned to effectively analyze and interpret data to derive meaningful insights and make informed decisions.
• Developed strong analytical skills through hands-on experience with various data analysis tools and techniques

• Improved ability to identify trends, patterns, and outliers in data sets

• Enhanced communication skills by presenting findings and recommendations to stakeholders

• Learned to collaborate with team memb
Answered by AI
Add your answer

Q1. SQL base Question
Add your answer
Q2. About your projects
Add your answer

Basic Apititude Questions

Q1. Difference between WHERE and HAVING??
Ans. 
WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.
• WHERE is used with SELECT statement to filter rows based on a condition

• HAVING is used with GROUP BY statement to filter groups based on a condition

• WHERE is applied before data is grouped, HAVING is applied after data is grouped

• Example: SELECT * FROM table WHERE column = 'value'

• Example: SELECT column, COUNT(*) FROM table GROUP B
Answered by AI
Add your answer
Q2. Where- Row Level Filters Having-Aggregate Filters
Ans. 
Row level filters are applied before aggregations, while aggregate filters are applied after aggregations.
• Row level filters are used to filter individual rows of data before any aggregations are performed.

• Aggregate filters are used to filter the aggregated results after the data has been grouped and summarized.

• Row level filters are typically applied using WHERE clause in SQL, while aggregate filters are applied using H...read more
Answered by AI
Add your answer

Q1. Why do you wanna join Uber?
Add your answer
Q2. Best Company Ever
Add your answer

It was basic MCQ related to Javascript

Q1. Asked basic questions related to array and SQL
Add your answer

Q1. Asked question to test the business context
Add your answer

Approx 30 questions which are to be solved in 1 hour. Questions include logical and mathematical questions along with basic ML and stats questions

Q1. Basic questions related to Python and SQL
Add your answer

Q1. Advance SQL questions and 1 case study
Add your answer

Q1. Basic ML questions and Business acumen questions
Add your answer

The aptitude questions were bit easy and there were questions about SQL, and also excel sheets.

Q1. Questions about sql
Add your answer