Flipkart | OA | 6th dec 2025 | SQL Coding: Invalid Phone Number Orders

Question 1: SQL Coding 1 (Invalid Phone Number Orders) Problem Statement: You are given two tables, one is named Customer with columns CustomerID, FirstName, LastName, Email, and Phone. The other is called OrderCustomer with columns OrderID, CustomerID, OrderDate, and BillValue. Write a query to display the CustomerID, FirstName, LastName, Phone, OrderID, OrderDate, and BillValue for all those customers who have placed orders with invalid phone numbers (A valid phone number consists of exactly 10 digits). The final result should be ...