Hacker rank practice sql problem. Medium SQL (Intermediate) Max Score: 30 Success Rate: 93.

Hacker rank practice sql problem Hacker Rank SQL practice upvotes Daily SQL problem-solving Slack community upvotes Write a query identifying the type of each record in the TRIANGLES table using its three side lengths. Subqueries and Nested Queries. Explanation. hacker_id group by c. Sample Input Revising the Select query I | HackerRank Sql solutionsWe are starting the hacker rank solution series providing the practice and teaching SQL problem-solving Problem. hacker_id as hackerid, name, count(c. com practice problems using Python 3, С++ and Oracle SQL - marinskiy/HackerrankPractice HackerRank SQL Solutions. Each solution includes a brief explanation of the problem and my approach to solving it. For example: AnActorName(A), ADoctorName(D), AProfessorName(P), and ASingerName(S). I had to determine the keys to the join and make jt run efficiently. 81041 Lisa 1. Challenges: The challenge_id is the id of the challenge, the hacker_id is the id of the Problem Solving (Basic) Solve Challenge. I also tried stratascratch and it's all good, everything is as you expect. SQL (Basic) SQL (Intermediate) Let's walk through this sample challenge and explore the features of the code editor. Also, a full solution without the need to change modes was posted by @dougal_michael below, which uses the MIN() function instead. This competency area includes the understanding of basic concepts like Two pairs (X 1, Y 1) and (X 2, Y 2) are said to be symmetric pairs if X 1 = Y 2 and X 2 = Y 1. Medium SQL (Intermediate) Max Score: 30 Success Rate: 97. Download problem statement. Easy Problem Solving (Basic) Max Score: 5 Success Rate: 98. Note. Status. Join the contest and write queries fast to climb the leaderboard. Hackerrank is a great platform to practice SQL queries. This repository contains all 58 solutions to the HackerRank SQL Practice Questions. The first row contains integer, . recency | 3248 Discussions| Please Login in order to post a comment. CountryCode and COUNTRY. ; Isosceles: It's a triangle with sides of equal length. Order your output by ascending company_code. To learn Pyspark, I have obtained data and answered questions from Hacker Rank. 93%. 3 days ago + 0 comments /* MS-SQL*/ with cte1 as (select *, months * salary as earnings from Employee) SELECT earnings, count (*) FROM cte1 WHERE earnings = (SELECT MAX (earnings) FROM cte1) group by SQL. Ketty doesn't want the NAMES of those students who received a grade lower than 8. HackerRank is a platform for competitive coding. Towards Data Engineering. 96196 Lisa 1. Each solution is crafted to address a specific SQL problem from the HackerRank SQL challenge set, covering various aspects of SQL including querying, joins, aggregations, and more. Prithviraj Biswas. Weather Observation Station 11. The output should consist of four columns (Doctor, Professor, Singer, and Actor) in that specific order, with their respective names listed alphabetically under each column. The CITY table is described as follows: Q1. Practice coding challenges & prep for interviews. Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table. It is intended to teach the anatomy of a programming contest. It was like 2 hours. But hey, second time's the charm, right? Boom! Write a query to generate a report containing three columns: Name, Grade and Mark. SQL (Basic) SQL (Intermediate) SQL Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. New Companies. SQL (Basic) SQL (Intermediate) SQL (Advanced Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. It is guaranteed that the difference between the End_Date and the Start_Date is equal to 1 day for each row in the table. Note: Print NULL when there are no more names corresponding to an occupation. 88255 Patrick 5. View editorial. HackerRank changed the default sql_mode behavior to only_full_group_by at some point after I posted this. 74842 Lisa 174. 39%. Contest Leaderboard. This collection serves as a useful resource for improving SQL skills and problem-solving techniques. 21283 Angela 6. Sweet, we've sent you an email confirming your registration! These concepts introduce more complex features and functionalities of SQL. HackerRank SQL Problems and Solutions — 1. PHP stands for Hypertext Preprocessor, and is integrated with a number of popular databases, including MySQL, PostgreSQL, Oracle, Sybase, Informix, and Microsoft SQL Server. Hackers Table: Challenges Table: Sample Output 1. Submissions. Japanese Cities' Names. hacker_id=h. This repository contains my solutions to various SQL challenges on HackerRank, organized by categories and difficulty levels. This repository contains my SQL solutions to HackerRank challenges, organized by difficulty: Easy, Medium, and Hard. Print Prime Numbers. You can view challenges of the previous SQL contest Simply SQL and also practice at SQL domain to prepare yourself for the contest. hacker_id, name ) select hackerid, name, cnt from comp where hackerid not in (select hackerid from comp where cnt in We define an employee's total earnings to be their monthly worked, and the maximum total earnings to be the maximum total earnings for any employee in the Employee table. Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. The report must be in descending order by grade Problem. Accuracy . . Two pairs (X 1, Y 1) and (X 2, Y 2) are said to be symmetric pairs if X 1 = Y 2 and X 2 = Y 1. 84072 Bonnie 100. Population) rounded down to the nearest integer. Skills. This competency area includes the usage of Exception Handling, Procedures, and Functions, as well as a good understanding of Type and Package. Okay, so my first crack at it? Let's just say it was more of a practice run. Field From table1 AS t" Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. Medium SQL (Intermediate) Max Score: 30 Success Rate: 96. Packages contains two columns: ID and Salary (offered salary in $ thousands per month). Output one of the following statements for each record in the table: Equilateral: It's a triangle with sides of equal length. It’s a spotlight problem. I think I ended up using dense rank. Population Census . Qu CREATE TABLE table_name (column1 datatype, column2 datatype-1 | Permalink. It took me a bit more than two weeks (on and off between work, Let's walk through this sample challenge and explore the features of the code editor. 2 of 6; Choose a language Select the language you wish to use to solve this Understand Window Functions: Functions like RANK(), DENSE_RANK() and ROW_NUMBER(). select a. View top submissions. Problem. e. ; Scalene: It's a triangle with sides of differing lengths. RANK, DENSE_RANK, LEAD, LAG. 40%. Pivot the Occupation column in OCCUPATIONS so that each Name is sorted alphabetically and displayed underneath its corresponding Occupation. ; Not A Triangle: The given values of A, B, and C Generate the following two result sets: Query an alphabetically ordered list of all names in OCCUPATIONS, immediately followed by the first letter of each profession as a parenthetical (i. ; Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. Hackers Table: Submissions Table: Sample Output. Link to HackerRank problem is here. recency | 1466 Discussions| Please Login in order to post a comment. This is the only video you will need to improve you Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. NET initiative, C# is a general-purpose, object-oriented programming language designed for Common Language Infrastructure (CLI), and widely recognized for its structured, strong-typing and lexical scoping abilities. Exercise your creativity in heuristic design. 83%. Solved. Editorial. Share on Facebook Share on Twitter Share on LinkedIn. x=b. Binary Tree Nodes. Stars. This competency area includes the usage of Bulk Collect, FORALL, Save Exception, Pipeline Function, and SYS_REFCURSOR. But hey, second time's the charm, right? honing problem-solving skills and deepening their understanding through HackerRank's challenges. Articles Works Shiny Snippets Resume About Contact. The AS keyword causes errors, so follow this convention: "Select t. They had to be ranked by some metric. Discussions. 4806 Angela 89. - All-HackerRank-SQL-Challenges-Solutions/README. Easy SQL (Advanced) Max Score: 25 Success Rate: 97. Difficulty: The difficult_level is the level of difficulty of the challenge, and score is the maximum score that can be achieved for a challenge at that difficulty level. 2 of 6; Choose a language Select the language you wish to use to solve this PL/SQL is an extension of SQL language that combines the data manipulation power of SQL with the processing power of procedural language to create super-powerful SQL queries. The SQL problem is taken from HackerRank. Field From table1 AS t" Sample Output. Write a query to find the node type of Binary Tree ordered by the value of the node. Medium SQL (Intermediate) Max Score: 30 Success Rate: 92. Developed around 2000 by Microsoft as part of its . Submitted By. 4 stars Download problem statement. The repository dedicated to solutions for Hacker-rank Database problems, solved with MySQL - hackerrank-sql-solutions/The PADS. cracking-the-coding-interview hackerrank hackerrank-python hackerrank-solutions hackerrank-java hackerrank-algorithms-solutions hackerrank-30dayschallange hackerrank-python-solutions hackerrank-sql hackerrank-problem-solutions hackerrank-sql-solutions hackerrank-practice hackerrank-problem-solving hackerrank-solutions-github hackerrank-all Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. y having (count(*)>1 and a. md Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. Mock Test. 50%. y group by a. HackerRank SQL Practice -Basic Select — Nikhitha Perapola. Jul 30, 2023. 170+ solutions to Hackerrank. SQL; Problem Solving Badges. Draw The Triangle 2. 74%. The output column headers should be Doctor, Professor, Singer, and Actor, respectively. Write a query to output all such symmetric pairs in ascending order by the value of X. Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. Solve Challenge. The notebook has been run using the Databricks Community These concepts require a deeper understanding of SQL and its ecosystem. 03%. Field From table1 t" instead of "select t. If the End_Date of the tasks are consecutive, then they are part of the same project. 75%. Basic Select. Whether you’re prepping for an interview or This repository contains my solutions to all the HackerRank SQL Practice Questions. tried this in oracle: with comp as ( select c. Problem 1. 2 of 6; Choose a language Select the language you wish to use to solve this Current projects at work require more SQL skills, so I took the time to brush up my SQL knowledge using the HackerRank coding challenges platform. Efficiency. akshithalachu68. It's frustrating. rate this challenge. 5 hours long? Because Im solving ALL of the SQL Problems on Hackerrank in this video. 79345 Frank 4. Lets say, Total submissions (one per hacker) for the challenge: Query the data for all American cities with populations larger than 100,000. Pivot the Occupation column so the Name of each person in OCCUPATIONS is displayed underneath their respective Occupation. This key competency includes a basic understanding of the PHP environment, predefined PHP arrays containing variables, understanding and ability to write code to perform Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. We shall use recursive sql to solve the given problem. Medium SQL (Intermediate) Max Score: 30 Success Rate: 93. x-1 | Solutions to HackerRank practice, tutorials and interview preparation problems with Python, SQL, C# and JavaScript - nathan-abela/HackerRank-Solutions Let's walk through this sample challenge and explore the features of the code editor. Hello coders, in this post you will get all the solution of HackerRank SQL Solutions. In. 15%. You are given a table, Projects, containing three columns: Task_ID, Start_Date and End_Date. Blog; Scoring; Environment; FAQ; Complex joins-This competency includes using INNER, LEFT, RIGHT, and FULL joins on multiple tables and using joins for many-to-many relationships. 65%. Feb 25, 2023 Mustafa Germec. Weather Observation Station 10. Basics of Sets and Relations #7. Let's walk through this sample challenge and explore the features of the code editor. These solutions can be used as a reference for other learners or as a way to practice and improve SQL skills. Sample Problem Statement: Given an integer N, print 'hello world' N times. Top Competitors. SQL (Basic) SQL (Intermediate) SQL The thing that bothers me with HackerRank SQL questions is that it doesn't show the SQL queries output properly, like with a table, with the column names etc. These solutions can SQL. Ollivander's Inventory. Blog; Scoring; Environment; FAQ; Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. Suggest Edits. Medium SQL (Intermediate) Max Score: 40 Success Rate: 97. 2 of 6; Choose a language Select the language you wish to use to solve this You are given a table, Functions, containing two columns: X and Y. , a, e, i, o, or u) from STATION. y=b. Write a query to find the maximum total earnings for all employees as well as the total number of employees who have maximum total earnings. These concepts introduce more complex features and functionalities of SQL. This collection serves as a practical guide for anyone Hackerrank is a great platform to practice SQL queries. where LAT_N is the northern latitude and LONG_W is the western longitude. Query a list of CITY and STATE from the STATION table. Need Help? View discussions. 2 of 6; Choose a language Select the language you wish to use to solve this Print the total number of challenges created by hackers. Leverage Query the list of CITY names starting with vowels (i. 1 day ago + 0 comments. There are a total of 58 problems of varying difficulty level that test different concepts. Readme Activity. Key Competencies: Medium SQL (Intermediate) Max Score: 30 Success Rate: 93. Code are Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. If you solve a challenge in an official HackerRank contest, you will earn points towards your progress once the challenge is added to the practice site. Hidden Input File The input file has rows (), each containing an integer. Regular practice helps you get better at using SQL and boosts your confidence in handling different database tasks. 92%. Sort by. 12299 Rose 6. The following tables contain contest data: Hackers: The hacker_id is the id of the hacker, and name is the name of the hacker. Students contains two columns: ID and Name. Print “NULL” as the name if the grade is less than 8. Friends contains two columns: ID and Friend_ID (ID of the ONLY best friend). Sample Input 5 Sample Output hello world hello world hello world hello world hello world Solutions by language: C #inc Download problem statement. This practice contest contains 5 tutorial problems. A median is defined as a number separating the higher half of a data set from the lower half. The second integer is the number of sessions on . Earn a HackerRank certificate. Sample Input 1. ; Advanced: Expert-level problems and more complex queries. 2 of 6; Choose a language Select the language you wish to use to solve this This repository contains solutions to Hackerrank practice problems in SQL, C++, Java Python and Problem Solving (Data Structures and Algorithms). 2 of 6; Choose a language Select the language you wish to use to solve this . This time, a Hacker Rank certificate for SQL (Basic). : enclosed in parentheses). Basic Join. 2 of 6; Choose a language Select the language you wish to use to solve this Sample Output. Medium SQL (Advanced) Max Score: 40 Success Rate: 93. Find the duplicates and delete them This repository contains my solutions to various SQL challenges on HackerRank, organized by categories and difficulty levels. The repository is organized as follows: Easy: Beginner-level SQL challenges. Attempts: 277935 Success Rate: 94. Each of the subsequent lines contains an integer denoting the number of user sessions for day (where ). SQL. Before You Hacker Rank SQL Problem Solving: My solutions to various HackerRank SQL problems using MySQL. It is very important that you all first give it a try & brainstorm yourselves before having a In this post, I’ll share my solutions to some SQL problems on HackerRank, categorized as “Easy. 02%. Select All. Hackers Table: Challenges Table: Sample Output 0. It’s not a pipeline problem. Some challenges include additional information to help you out. It will be open for 24 hours, but make sure you start early because the tiebreaker is the time from the beginning of the contest. List the rows such that X 1 ≤ Y 1. Reason: Window functions provide powerful tools for performing Let's walk through this sample challenge and explore the features of the code editor. Then print these values as space-separated integers. SQL Project Planning. Why this video is 7. y) or a. 1 of 6; Review the problem statement Each challenge has a problem statement that includes sample inputs and outputs. hacker_id) cnt from challenges c inner join hackers h on c. You are given three tables: Students, Friends and Packages. 80491 Patrick 3. 2179386. Medium SQL (Intermediate) Max Score: 20 Success Rate: 96. A participant's total score is the sum of the scores earned for each problem attempted. 2 of 6; Choose a language Select the language you wish to use to solve this SQL. 12299 Rose 6 34856 Angela 6 79345 Frank 4 80491 Patrick 3 81041 Lisa 1 These concepts require a deeper understanding of SQL and its ecosystem. Click here to see solutions for all Machine Learning Coursera Assignments. SQL (Basic) SQL (Intermediate) SQL select case when a+b > c and b+c > a and a+c > b then case when a=b and b=c and a=c then 'equilateral' when a=b or b=c or a=c then 'isosceles' when a<>b and b<>c and a<>c then 'scalene' end else 'not a triangle' end as type_of_triangle from triangles; This time, a Hacker Rank certificate for SQL (Basic). So, without wasting any time, let’s jump to the solutions. Medium SQL (Intermediate) Max Score: 40 Success Rate: 93. Attempts: 380523 Challenges: 1 Last Score: -Skills: Problem Solving (Basic) Take this mock test to evaluate how much you've learned till now. The solutions of all the SQL challenges for all easy, medium and hard challenges on HackerRank executed on MySQL environment compiled with helpful Resources & references related to the challenges. Sample Output. The output is in a "code-ish" format. 82%. 20 20 20 21 22 23 Post displaying HackerRank sql problem solving questions and solution. 06%. Write a query to output the names of those students whose best friends got offered a higher Download problem statement. It is organized into six folders, each containing my solutions for easy, medium and difficult challenges executed in a MySQL environment. You can take the test as many times as needed. From prepping for jobs and practicing coding to running a world-class technical interview, give developers the tools they need to showcase their skills, passion, and potential. Published on Sample Input. Unions-This competency includes using unions to display multiple sets of information Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. Download sample test cases. African Cities. Query the median of the Northern Latitudes (LAT_N) from STATION and round your answer to decimal places. 2 of 6; Choose a language Select the language you wish to use to solve this This repository contains my solutions to various SQL challenges on HackerRank, organized by categories and difficulty levels. Tech hiring needs a reset. Blog Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. You are given a table, BST, containing two columns: N and P, where N represents the value of a node in Binary Tree, and P is the parent of N. Your score for a problem depends on the number of test cases your submission successfully passes. debjyoti_ghosh. Easy SQL (Intermediate) Max Score: 30 Success Rate: 94. They are essential for building more sophisticated and robust queries, managing data relationships, and optimizing query performance. x and a. Each solution is accompanied by comments for clarity, showcasing various approaches and optimizations. x, a. recency | 850 Discussions| Please Login in order to post a comment. For example, if there are three records in the table with CITY values 'New York', 'New York', 'Bengalaru', there are 2 different city Let's walk through this sample challenge and explore the features of the code editor. thank you so much! really helped. 99%. Unsolved. mysql Easy SQL (Advanced) Max Score: 25 Success Rate: 96. 2 of 6; Choose a language Select the language you wish to use to solve this Download problem statement. 95%. Challenges. You are given two tables: Students and Grades. 80305 Kimberly 67. Learn how to use them effectively with the OVER() clause, including the ORDER BY and PARTITION BY options. SQL (Basic) SQL (Intermediate) SQL PL/SQL is an extension of SQL language that combines the data manipulation power of SQL with the processing power of procedural language to create super-powerful SQL queries. Easy Problem Solving (Basic) Max Score: 5 Success Rate: 97. N)>0,"Inner","Leaf")) FROM BST AS B ORDER BY N; Disclaimer: The above Problem (Binary Tree Nodes) is generated by Hacker Rank but the Solution is Provided by CodingBroz. 1. Download This repository contains my solutions to all the HackerRank SQL Practice Questions. Download the dataset Medium SQL (Intermediate) Max Score: 30 Success Rate: 93. Employee Salaries. If you feel this repo is helpful for you, please do star it. The OCCUPATIONS Edits: Updated with the sql_mode='' based on @jakab922's comment. Samantha is interested in finding the total number of different projects completed. Revising the Select Query I mysql practice solutions hackerrank problem-solving hackerrank-solutions hackerrank-sql hackerrank-sql-solutions Resources. Whether we are beginners or experienced professionals, practicing SQL exercises is important for improving your skills. sql at master · Shounok/hackerrank-sql-solutions SQL. These solutions can In this post, we will be covering all the solutions to SQL on the HackerRank platform. Solution to HackerRank SQL Practice Questions. x=a. 24%. ; Medium: Intermediate-level SQL challenges. Note: CITY. SQL (Structured Query Language) is a powerful tool used for managing and manipulating relational databases. Usage Feel free to refer to these solutions for learning purposes. Going through them greatly improved my ability to Amber's conglomerate corporation just acquired some new companies. The comments at the top of each SQL file provide a brief description of the problem, the solution approach, and any additional notes. The STATION table is described as follows: . Challenges related to bot-building, path planning, search techniques and Game Theory. ” I used the MySQL option on the platform to solve each of the challenges. You earn badges by solving challenges on the various practice tracks on our site. 34856 Angela 6. ; Hard: Advanced-level SQL challenges. Sample 2. The STATION table is described as follows:. Revising the Select Query I – HackerRank Solution Given the CITY and COUNTRY tables, query the names of all the continents (COUNTRY. Activities involved: Writing and using subqueries in SELECT, FROM, WHERE clauses. Query the number of ocurrences of each occupation in OCCUPATIONS. HackerRank SQL Question 13. It was python and sql. Students contains three columns ID, Name and Marks. Kamireddy Mahendra. Note: Print NULL when there are no more names 2. supriya22399. Each of the companies follows this hierarchy: Given the table schemas below, write a query to print the company_code, founder name, total number of lead managers, total number of senior managers, total number of managers, and total number of employees. Leaderboard. 26071 Frank 85. Ketty gives Eve a task to generate a report containing three columns: Name, Grade and Mark. Open main menu. Continent) and their respective average city populations (CITY. You are registered for the contest. Grades contains the following data:. Placements. Sample Input. The case (uppercase or Each solution is designed to demonstrate various SQL techniques and best practices, with clear comments to enhance understanding. Welcome to the HackerRank SQL Solutions repository! 🚀 Dive into a curated collection of SQL queries crafted to tackle a range of challenges. Time Conversion. As I recall the sql portion required grouping and aggregating visitors or some events. Sep 15, 2024. 63% Skill: Problem Solving (Basic) Solve Challenge. 4071 Rose 191. If you are interested in adding more Hackerrank problem solutions, please feel free to contribute. #hackerrank#sql#skills#certification. 26%. Blog; Scoring Basics of Problem Solving Learn the basics of problem solving. 2 of 6; Choose a language Select the language you wish to use to solve this Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. Click here to see more codes for Raspberry Pi 3 and similar Family. For Sample Case 0, we can get the following details: Your score for a problem depends on the number of test cases your submission successfully passes. They are necessary for optimizing performance, managing complex queries, ensuring data integrity, and leveraging advanced features for high-level query design and development. The first integer is the number of sessions on . Consider the following table with the Download problem statement. by. y from functions a join functions b on a. Guestbook. Advanced Join. Your result cannot contain duplicates. Multiple Choice Question Max Score: 2 Success Rate: 67. 2 of 6; Choose a language Select the language you wish to use to solve this Sample Input 0. Weather Observation Station 20. 1 Leaf 2 Inner 3 Leaf 5 Root 6 Leaf 8 Inner 9 Leaf Solution – Binary Tree Nodes in SQL MySQL SELECT N, IF(P IS NULL,"Root",IF((SELECT COUNT(*) FROM BST WHERE P=B. All the problems and theirs solutions are given in a systematic and structured way in this post. Click here to see more codes for NodeMCU ESP8266 and similar Family. Relational Algebra - 3. Start practicing your skills Pivot the Occupation column in OCCUPATIONS so that each Name is sorted alphabetically and displayed underneath its corresponding Occupation. If you submitted more than one solution for a problem, only your highest score achieved will be used in this calculation. 2 of 6; Choose a language Select the language you wish to use to solve this A fantastic place to practice SQL questions is Hacker Rank. Input Format. MORE DETAILS. Maria 10 99 Jane 9 81 Julia 9 88 Scarlet 8 78 NULL 7 63 NULL 7 68. Demonstrate your Problem Solving, SQL, REST API Skills. HackerRank SQL Solutions. Speed . Develop intelligent agents. PL/SQL is an extension of the SQL language that combines the data manipulation power of SQL with the processing power of procedural language to create super-powerful SQL queries. Revising the Select Query I. In this video, we will learn how to solve a complex SQL query. Blog Let's walk through this sample challenge and explore the features of the code editor. 7 hours ago + 0 comments. The second was a large set of tables that needed to be joined together. tnxwjw yoxzxuq xnrttx ugte hyftdu fohqxtp umnfx qctvvz jwhtmi cxw