Write an SQL query to retrieve the top N products based on their total sales. Who Made Quota? Practice real SQL Interview Questions asked by Amazon, Google, Facebook (Meta), and other FAANG companies during Data Science and Data Analyst interviews. However, if you’ve only got a few days or hours to cram for a SQL assessment, checkout this guide on how to cram for SQL assessments. The category of T-SQL questions contains the most questions, which reflects its importance. Each SQL question has multiple hints, full answers and most importantly, there's an interactive SQL code editor so you can instantly run your SQL query and May 26, 2023 · Conclusion. Answer: To find the second-highest salary in a table, you can use a subquery with the LIMIT clause: SELECT DISTINCT salary. The Result Table. Jan 1, 2024 · Structured Query Language (SQL) is the standard programming language used by database administrators and data analysts to query databases. This should serve only as a guideline Nov 2, 2019 · This is especially true if you are going to interview at a top tech company such as Amazon, Apple, or Google. Event Friends Recommendation [Facebook SQL Interview Questions] Facebook wants to recommend new friends to people who show interest in attending 2 or more of the same private events. Interview Question 1: Find the Average Salary by Department. Cafe - 1704 Data Science & ML Interview Questions & Answers! Mar 2, 2024 · SQL Question 1: Compute the average rating per product per month. I consider these questions essential for everyone aspiring for a job as an SQL developer. Include the product name, sales amount, and any other relevant details. Write an SQL query to report the client_id and client_name of clients who have spent at least $100 in each month of June and July 2019. Meta/Facebook is all about data, and this data is created by you. Table for Questions 1, 2, and 3. Oct 13, 2023 · These questions not only test your ability to write complex queries but also assess your problem-solving skills within the context of database management. 32%, while Oracle grew by 3. Articles, videos, tutorials, and interview questions and answers related to software development technologies. Bloomberg. Our result set contains every combination possible between the two tables. Return the answer rounded to 2 decimals places. Tell me about SQL. Jan 26, 2024 · Besides solving the earlier eBay SQL interview questions, you should also solve the 200+ SQL questions on DataLemur which come from companies like Facebook, Google and unicorn tech startups. e) INDEX: This SQL constraint indexes a table field to facilitate a quicker retrieval of records. While my best-selling book, Ace the Data Science Interview, has successfully helped 16,000+ readers prepare for the Statistics, ML, and Business-Sense portions of data interviews, readers kept asking for a more interactive way to practice the 201 questions from the book. Jun 11, 2024 · Let us start by taking a look at some of the most asked SQL Query interview questions:. Onsite interview structure. Meta interview details: 12,950 interview questions and 11,787 interview reviews posted anonymously by Meta interview candidates. Feb 14, 2024 · Some queries might evaluate the candidate's technical skills and their coding and reasoning abilities. Please write a SQL query to compute the average rating for each product per month. Talk about a time you worked as a team. "Activity" in this context is defined by the number of videos a user uploads. tar folder as shown below: pg_dump -U postgres -W -F t sample_data > C:\Users\admin\pgbackup\sample_data. Along these lines, information examiners at Facebook work in a wide range of groups and are incredibly cross-utilitarian. Understanding the difference between different datetime variable types in SQL. In-person (or video) live coding session where you're asked to use SQL skills to answer questions in real time. Example: "PL/SQL has four predefined data types, which are scalar, composite, reference and large object. Describe a situation where you would decide to use a blank space or a zero instead of a NULL value within a row. The types of SQL interview questions that data analysts get generally fall into these three categories of increasing difficulty. When you search table data with an SQL query, it will search the whole table and return the result. " Dec 25, 2023 · SQL Question 2: Adobe User Behavior. (Ex-Facebook & Best-Selling Data Science Author) At Snowflake, SQL is used quite frequently for querying and analyzing large datasets in the cloud and managing data warehouse infrastructure for optimization and scalability. They provide an efficient and accessible way to access and combine information in your database. Sometimes, the initial interview screen will involve conceptual questions to test whether you have sufficient May 31, 2023 · This integrity means that a table’s relationship with other tables is established because of its primary key. Nov 27, 2019 · It’s highly suggested to write in SQL as this is the language that all of the analysts and data scientists use at Facebook. . In a recent Amazon data analyst interview, the candidate was given the reviews table, and asked to write a SQL query to get the average stars for each product every month. Write an SQL query to find the average daily percentage of emails that get removed after being reported as spam, rounded to 2 decimal places. 26. Calculate the share of new and existing users. Second, they can use the knowledge you have currently to tell a convincing story about the future. Write a SQL query to include the number of Mondays between the two given dates. Facebook uses its information to improve and upgrade all that you can consider, from its items to its showcasing systems to its inner activities and then some. For this question, suppose that Adobe considers an active user as someone who has used any one of their products more than 4 times in a month. Dec 4, 2021 · Write an SQL query to find the overall acceptance rate of requests, which is the number of acceptance divided by the number of requests. From my experience the process is the following: 1) call with recruiter (15-30 min) 2) tech screening (60 min with live coding in SQL and Python) 3) onsite interview (data modelling, behavioral questions) Interview questions [1] Question 1. A SQL cheat sheet for interviews is a valuable resource for honing your SQL skills and boosting your confidence in data analysis and data science job interviews. SQL injection is a flaw in a code that allows attackers to take control of back-end processes and access, retrieve, and delete sensitive data stored in databases. Most common Meta/Facebook SQL questions. The Result Explanation. New users are defined as users who started using services in the current month. Apr 6, 2021 · Role Of Data Analyst In Facebook | SQL Interview Questions. SQL interview questions: Defining SQL terms. Whether you’re gearing up for an interview or simply looking to enhance your SQL knowledge, these questions provide valuable insights into the coding challenges and technical assessments associated with Meta/Facebook interviews. We have two tables, orders and order_items. In contrast to a primary key, a table has the flexibility to incorporate multiple unique keys. " 29. May 29, 2024 · Crack the top 40 SQL interview questions. Write a query to calculate the click-through rate (CTR) for the app in 2022 and round the results to 2 decimal places. A power user, as defined by Apple, is a customer who has at least made 10 in-app purchases each month in the last year. Feb 1, 2021 · Every company does things differently, but here are a few of the more common ways companies test SQL skills: In-person (or video) interview where you're asked SQL questions or given SQL problems to solve. Note That –. GROUP BY, WHERE, and HAVING. According to research SQL by Microsoft grew at 10. 5 hours long with little breaks in-between each interview. SQL database market continues even stronger by 2024 will be 70%. Subsetting by date and time ranges. Mar 14, 2021 · The 4-step approach to solve this SQL data analyst interview question. Write a SQL query to retrieve all the records from a table named “customers”. The data includes the user_id, name, status of the account, and the country of origin of the account. You may want to include the reasons below in your answer: Parallel Queries: PostgreSQL makes it possible to run parallel queries. Jun 11, 2024 · By executing queries, SQL can create, update, delete, and retrieve data in databases like MySQL, Oracle, PostgreSQL, etc. Following is a curated list of Facebook SQL interview questions: May 30, 2024 · The following SQL interview questions for developers will help you practice the most frequently asked questions. Each exercise has hints to guide you, full answers and best of all, there is an interactive SQL code editor so you can instantly run your query and 10 Snowflake SQL Interview Questions (Updated 2024) By Nick Singh. • Find the number of matches played, won, lost and tied by each team in Asia cup. Explain the importance of data quality in SQL-based data analysis. Manipulation of interval, datetime and timestamp columns. Write a SQL query to fetch “FIRST_NAME” from the Student table in upper case and use ALIAS name as STUDENT_NAME. May 13, 2020 · 10 Advanced SQL Job Interview Questions and Answers. Apr 17, 2024 · Knowing these questions will boost your confidence and give you an edge for landing a dream job. It is highly desirable as Database Management Systems are used in almost every software application. 204 members. • Find start and end values of a Some of the most tested SQL datetime function groups in Facebook SQL scenario based interview questions include. As a Data Analyst for TikTok, you've been asked to identify the users who are the most active on the platform. STAR asks you to consider situations, tasks, actions and responses to create the foundation for applicable answers. Interviewers use them to test your gumption, which is typically a result of extensive experience and a high level of SQL knowledge. Didn't pass the tech screening. This SQL data science interview question was asked by Facebook. Check out our ultimate guide to SQL interview questions for 2021 here. Step 1: To calculate the average salary by department, we will need to first run a SQL query that selects the dept column from the employee table in the relational database. Feb 26, 2024 · The shared columns between two tables will be eligible for this kind of join. This article, “Scenario-Based SQL Interview Questions and Answers,” is your comprehensive guide to acing SQL interviews by delving into various real-world scenarios. Question 1: What is an index? What are the two main index types? An index is a structure in a database that can help retrieve data faster. To do this, the STAR method of answering interview questions is a resource. Below are seven examples of the kinds of problems a data scientist or software engineer might face during a technical interview. The accepted requests are not necessarily from the table friend_request. Practice real SQL Interview Questions asked by Amazon, Google, Facebook (Meta), and other FAANG companies during Data Science and Data Analyst interviews. This is the best place to expand your knowledge and get prepared for your next interview. Glassdoor has millions of jobs plus salary information, company reviews, and interview questions from people on the inside making it easy to find a job that’s right for you. SQL. SQL first appeared in 1974. Adobe has an extensive database of its customers. Write a SQL query to list all of the Apr 17, 2024 · 22 SQL Interview Questions and Answers (Basic to Advanced) Here are the essential SQL interview questions and answers to know to prepare for your big day and land the SQL job of your dreams. Mar 24, 2021 · Here's a step-by-step framework to solve any data science SQL interview question. 9-Day Interview Crash Course! (which covers Probability, Statistics, ML, Coding, & Product-Sense). 9. It is used when the exact time (as well as the date) of an event has to be recorded – e. 4. Talk about a time you solved a problem on your own. The output should include the month in numerical Jun 7, 2024 · I interviewed at Meta. Mar 14, 2017 · It contains over 600 interactive SQL exercises to help you review and practice SQL before an interview. (Examples of DCL statements include: GRANT, REVOKE). Oct 13, 2022 · Facebook interview questions can be divided into general, behavioral, and competency-based questions that can vary widely based on the job profile you’re interviewing for. In this article, I’ll help you prepare for the by going over some common questions and SQL exercises that recruiters use during the interview process. Jan 22, 2024 · SQL Question 1: Identify Apple's In-App Power Purchasers. SELECT SUBSTRING (lname, 1, 4) FROM Employee; 4. Jan 29, 2024 · 5 SQL Interview Questions for Amazon BIE. Question: Find the Second Highest Salary. This SQL cheat May 30, 2024 · SQL Interview Questions. October 20, 2021 by Manvendra Singh. If you need expert assistance to prepare for Facebook interview Apr 1, 2024 · These questions should help you assess an applicant’s problem-solving and critical thinking skills — both of which are important for SQL roles, from beginner to advanced. SQL queries can be used to create cohorts and track their behavior over time. I wa Feb 27, 2024 · 8. FAANG Stock Min-Max (Part 1) SQL. Extracting part of the datetime fields. the date and time an order was placed or shipped, user logins and logouts, or employees’ work hours. C:\>cd C:\Program Files\PostgreSQL\10. Photo from Pexels. Step 2: Next, we can use a simple calculation to find the average salary for each department. This article will walk you through some SQL interview questions and answers to help you with a job change or if you want to improve your interview skills. Yes. g. 0 Mar 16, 2023 · They include the static cursor, dynamic cursor, forward-only cursor and keyset-driven cursor. Poor data quality can lead to incorrect insights and decisions. In this case, Count the total accepted requests (no matter whether they Interview. • Find Min and Max values of continuous sequence in a group of elements. Interview Question 2: Find the Highest Salary by Department. Let's say we have an input field that takes a phone number, and we use it to build this SQL query: String sqlText = "SELECT * FROM customers WHERE phone = '" + phoneInput + "';"; Jan 18, 2024 · Single Table Queries. The interviewer will test your knowledge of basic SQL constructs. Because of this, Snowflake almost always asks SQL Apr 26, 2023 · They can also include questions about database management, data normalisation, and data security. Jan 24, 2024 · In addition to solving the earlier IBM SQL interview questions, you should also solve the 200+ SQL questions on DataLemur which come from companies like Facebook, Google and unicorn tech startups. Medium. Common aggregate functions include COUNT (returns the number of rows), SUM (returns the sum of all values in that column), AVG (returns the average value), MIN (returns the smallest value) and MAX SQL Interview Questions and Answers. Overall, SQL is a query language that communicates with databases. Question 3: Select Cats of a Given Age and Breed. We recommend these articles for a quick recap before a SQL interview: Complete SQL Practice for Interviews; The Top 10 SQL JOIN Interview Questions and How to Answer Them; Top 9 SQL GROUP BY Interview Questions; This, of course, is just the tip of the iceberg. Explain what a query in SQL is: A query is a request to retrieve specific data from the database. 2 days ago · Hide Answer. Differences: Questions that ask for the difference between two similar concepts. Questions about a query. It is used to access and manipulate data in a database, including creating and modifying tables and columns and querying Oct 20, 2023 · In this article, we’ll cover the top 15 SQL coding interview questions, along with detailed explanations and code examples. Oct 19, 2023 · The 29 interview questions we presented (and answered) include general, T-SQL, intermediate, and advanced SQL Server interview questions. In SQL, an aggregate function uses the data from multiple rows to calculate a single result. Easy. Assume you have a table named "Sales" with columns "ProductID," "ProductName," and "SalesAmount. Oct 22, 2021 · Advanced SQL scenario based Interview Questions and answers with detailed explanation and results. Forms query analysis questions may take: Given a query, Put the clauses in order by how SQL would run them. What you like, comment and post as a user is collected and analyzed on a regular basis. SQL Interview Questions. Jan 20, 2022 · In your interview, you may be asked why PostgreSQL is a good choice for data engineering. Question 2: Filtering Data in an SQL Query. In the upcoming era, the competition will be more heated than it has been for years. This strategy is widely utilized using data-driven apps to get access to sensitive data and execute administrative tasks on databases. In particular, power users are defined as customers who Mar 25, 2024 · 11. Whether you’re looking to hire a database administrator, QA tester, software engineer, or business analyst, you need to assess your candidates’ SQL Feb 20, 2020 · In this article, I've covered some basic questions and answers that could come up in an entry-level SQL interview. Teradata, a database and analytics service provider, places a great emphasis on customer engagement. Jan 22, 2024 · 6 Real Amazon SQL Interview Questions. Even when the tables used have little data, such as our employees and departments tables, it can produce a massive result set when they are used in conjunction with the SQL CROSS JOIN clause. Relational Database Management is an important part of Data Science and SQL is the most-used language in data science, according to the 10,000+ data professionals who responded to StackOverflow's 2020 survey. Other questions may test their knowledge of fundamental SQL concepts, principles and terminology. This tests your ability to read, interpret, analyze, and debug code written by others. For the purpose of this question, a "power user" is considered as a customer who frequently uses Teradata's services to run queries. It’s the most commonly tested concept on Facebook's coding interviews, especially in t WPF 46. Write a SQL query to retrieve the first name, last name, and email address of all customers whose last name is “Smith”. Take-home SQL task or tasks. It is widely used in the programming languages of websites, apps, and other platforms. This is when CPU power is leveraged to allow the running of multiple queries at once. This guide will cover basic SQL syntax as a refresher and then list some common SQL interview questions. The star rating ranges from 1 to 5, where 1 is the worst and 5 is the best. Web Security 58. The onsite interview at Facebook is a quick 2. Informatica has a 'reviews' table, where every row indicates a review for a product on a certain day rated by a user. Output the month, share of new users, and share of existing users as a ratio. If you’re seeking a career in data science, data analysis, or plan on working with databases at all, consider adding SQL (Structured Query Language) to Oct 4, 2023 · 2. Join group. SQL Server is an RDBMS database system mainly developed for the Windows system to store, retrieve, and access data requested by the developer. Explain what data control language (DCL) is: DCL statements are a subset of the SQL command set and they allow you to manage the access and rights of a database. We’ll go through these four main concepts and a few more besides: JOINs. That’s why they include SQL questions both in the technical screening and the onsite interviews. Write a query to estimate the average of the numbers that a user enters. Structured Query Language or SQL is a domain-specific programming language for managing data in Database Management Systems. Query to Find the Average Salary from an Employee Table Mar 10, 2021 · This is the most common data science interview question from Facebook. Jun 7, 2024 · 4. Feb 9, 2024 · Here are some advanced SQL query interview questions: Q38. Name and Explain Some Common Aggregate Functions. d) DEFAULT: This SQL constraint assigns a value by default if no value is assigned to a field. I have also tried to attach supporting articles for each question to help you learn more in-depth about the specified Jan 22, 2024 · SQL Question 2: Identify TikTok's Most Active Users. 7,137 Reviews. Data quality ensures that the data used for analysis is accurate, complete, and consistent. Mar 2, 2024 · SQL Question 1: Identifying Power Users at Teradata. Get prepared and confident for your tech interview. Write a query to obtain number of monthly active users (MAUs) in July 2022, including the month in numerical format "1 SQL is the most important skill for a data scientist. Of course, that doesn't mean you don’t need to know anything but those eight questions and answers. Basic SQL Whiteboard Questions for Job Interviews Jun 30, 2021 · 5. Your goal should be to measure their capacity for Mar 2, 2024 · SQL Question 1: Identify Top Spending Customers at Ocado. 🤖 Having Machine Learning & DS Interview? Check MLStack. Ocado is an online supermarket, and one of the ways to identify "power users" or "VIP users" for such a business is to find customers who have made frequent and large amount of transactions. Top 15 SQL Coding Interview Questions: 1. iOS 36. They often want to focus on active users who are highly engaged with their products. tar. Often referred to as a unique constraint, a unique key guarantees that every value in a column (or a combination of columns) remains distinct and cannot be replicated within a table. You can answer by listing PL/SQL data types and explaining their use. Step 2: Execute pg_dump program to take the dump of data to a . Mind you, these are not necessarily complex Jan 2, 2024 · Construct an SQL query to retrieve the first four characters of the ‘lname’ column from the Employee table. Feb 23, 2023 · This article contains the 27 most commonly asked advanced SQL interview questions and provides detailed answers and resources for further reading. ·. If possible, I try to avoid all cursor types unless absolutely necessary. This is the same question as problem #1 in the SQL Chapter of Ace the Data Science Interview! Assume you have an events table on Facebook app analytics. 60 min of SQL and Python (30 min and 3 6. Also, stop entering numbers as the user enters 1. The two types of Facebook SQL interview questions that recruiters ask are definitions and queries based. Table: Sep 27, 2022 · This collection of interview questions on SQL has been collated from my experience with SQL and from various websites. Find the top 3 customers with the highest total spending in the past year, excluding orders placed during specific promotional periods. It is a fast, scalable, and easy-to-use database. MySQL is the popular database management system used for managing the relational database. It’s true. Sep 13, 2022 · Answer: DATETIME is a date and time data type in MySQL. From your first line of code, to your first day on the job — Educative has you covered. Solution Query. Types of SQL interview questions for data analysts. Hiring managers want to know that you're able to use T-SQL properly. Active User Retention [Facebook SQL Interview Question] This is the same question as problem #23 in the SQL Chapter of Ace the Data Science Interview! Assume you're given a table containing information on Facebook user actions. Keep reading to discover an approach which can cover varying datasets and avoids the pitfalls of other strategies! Oct 24, 2023 · Ace your Facebook SQL interview with our in-depth Q&A guide, tailored to help candidates navigate through common and challenging SQL queries. SQL & Data Interview Questions. Third, that the candidate can think on the spot about trends you see This group has been created to help individuals with answers of there queries to prepare for interviews. Explore the data to take a look at how it behaves. I will show you 15 tricky SQL interview questions (mostly coding) in this article. Research And Development. Sort your results in order of user_a_id and user_b_id (refer to the Example Output below). Definition and note: To avoid integer division, multiply the CTR by 100. By mastering the concepts covered in this cheat sheet, you’ll be well-prepared to tackle any SQL-related interview questions and showcase your expertise. Nov 29, 2023 · 2. Construct a new table with data and structure that are copied from the existing table ‘Employee’ by writing a query. Want to practice more SQL interview questions like this with on-demand support and a dynamic SQL playground? Apr 23, 2023 · This Facebook (Meta) SQL interview question for the data scientist position can be solved in several ways, but we’ll cover the most flexible solution. In this article, we cover 70+ SQL Interview Questions with answers asked in SQL developer interviews at MAANG and other high-paying companies. I’ll cover both the question and answer and give a detailed explanation of the approach. Programmers also can define custom data subtypes. Public group. That's why I made DataLemur, an interactive SQL & Analytics interview Feb 14, 2021 · Why it's effective: This question shows three things: first, that the candidate has done enough research on the company and the industry that you can use it to make predictions. Xamarin 83. Existing users are users who started using services in the current month and Dec 15, 2022 · For Data Analysts and Data Scientists who’ve used SQL extensively at work, it takes 30 to 60 days to ace SQL interview questions at companies like Amazon, Google, and Facebook. It contains a list of questions of different types: Definitions: These questions ask for a definition of a term or concept. WebSockets 26. Apple maintains a database of its customers who have made purchases from their App Store. Below are seven interview questions with example answers that can help you prepare in advance for an SQL interview. Apr 1, 2024 · There are a lot of opportunities from many reputed companies in the world. 7. jQuery 51. This question tests your knowledge of the difference between NULL, blank, and zero, which all output “nothing” for the end-user. A "power user" is someone who has uploaded more than 1000 videos. With Meta’s backend handling billions of data fetch operations each day, knowledge of SQL is very important for the company's data engineers. Using JOINS can reduce data usage and storage on the database. Feb 3, 2023 · Being able to tie your experiences to your answers during the interview process is an important skill. Practice the most common SQL, Statistics, ML, and Python questions asked in FAANG Data Science & Data Analyst interviews! Practice real SQL Interview Questions asked by Amazon, Google, Facebook (Meta), and other FAANG companies during Data Science and Data Analyst interviews. May 29, 2024 · 3. 3 SQL questions. Question 5: Find the Most Bored Cat. Oct 20, 2021 · SQL Interview questions and answers. Apr 20, 2021 · Data Science SQL Interview Question. Join 2M+ developers learning in-demand programming skills. Follow along and check the 23 most common and advanced SQL Interview Questions Data Scientists and Machine Learning SQL injectionis when a hacker gains access to our database because we used their malicious user input to build a dynamic SQL query. Level up your coding skills and quickly land a job. 5. 5%. Answer: I would use a query similar to the following (assuming a table structure with orders and customers): Aug 12, 2022 · 7 Advanced SQL Interview Questions. The orders table contains the customer_id, order_id Oct 19, 2023 · SQL interview questions for experienced users usually contain some trick (y) questions. It contains both date and time values in the format ‘YYYY-MM-DD hh:mm:ss’. This second category of questions gives you an SQL query and asks you a question about it. Dec 2, 2023 · The hiring manager may use this question to test your ability to manage different data types in PL/SQL. The answers for all questions are given and you can use this information to study for your programming interview. Jun 21, 2022 · Next, we recommend you do some reading to review popular SQL interview topics. Jan 3, 2024 · The steps are as follows: Step 1: Navigate to the bin folder of the PostgreSQL installation path. Nov 2, 2022 · Solution. Write a SQL query to get the average review ratings for every product every month. We'll cover a brand new data science interview question from Twitch where I SQL joins are crucial in SQL management for multiple reasons, including: SQL JOINS are key methods to integrate multiple tables so they are easy to read and. CTEs (Common Table Expressions) and recursive queries. 0\bin. New And Existing Users. Define a Unique Key in SQL. You can interpret the remaining rows in the result in the same way. Solution Query Explanation. Question 1: Elements of an SQL Query. Question 4: List Cats Whose Favorite Toy Is a Ball. Of course, depending on the candidate’s response, you can add questions to explore further or clarify points. As we said at the beginning, writing T-SQL queries is a shared requirement for all the data jobs that work with Oct 20, 2022 · Our series of interview question walk-throughs marches on! Today we’ll be dealing with the advanced Meta/Facebook SQL question. Interview. Data for Questions 3 – 6. Dec 9, 2020 · 5. The task is to identify the power users of the App Store. Name five commands that can manipulate text in the T-SQL code. 1. Nov 24, 2021 · Table of Contents. These questions all test SQL and relational database skills, and are meant to be solved in a collaborative integrated development environment (IDE). 25. • Generate Cricket match fixtures for Asia Cup. Store. Apr 16, 2024 · To prep for the DoorDash SQL interview it is also helpful to practice SQL questions from other tech companies like: Uber SQL questions; Facebook SQL questions; Spotify SQL questions; TikTok SQL questions; However, if your SQL skills are weak, forget about going right into solving questions – refresh your SQL knowledge with this DataLemur SQL It depends a lot on what you're doing, but here's some ballpark questions I'd expect (source: was in a few interviews fairly recently) Very general questions: Talk about a time you solved a difficult problem. et zb xf dk uc qr ay qm gi wm