Use a subquery to show events which happened since the last one for a particular country occurred. 25 min read. Create a subquery showing all events which have happened since the last one involving the European Union. Prevent anyone deleting events in the UK with an INSTEAD OF DELETE trigger. SQL Retrieve data from tables [33 Exercises] SQL Boolean and Relational operators [12 Exercises] SQL Wildcard and Special operators [22 Exercises] SQL Aggregate Functions [25 Exercises] SQL Formatting query output [10 Exercises] SQL Quering on Multiple Tables [7 Exercises] FILTERING and SORTING on HR Database [38 Exercises] SQL JOINS Practice. Get used to using websites like SQL Fiddle and SQL Test so that you can practice … Create a correlated subquery to list out all countries having more than 8 events. Add rows one by one within a loop into a temporary table that you've created. Create a stored procedure to show all delegates from a training database where the company name and category name equal parameters (which can be null). Something to while away the time - convert a string of trainer ids into a string of table names, using any method you prefer!. Create a query to output a results set of historical events to an Excel workbook. Use a trigger to log when anyone adds, deletes or renames a country. Wiki. Create a procedure to list out the companions for a given doctor. The required query is: Select FIRST_NAME AS WORKER_NAME from Worker; Q-2. Create various simple queries, showing the use of IS NULL for criteria and date criteria. Introduction. Create a list variable to store all the events released in a specified year. Store useful information about continents in a new permanent table. Auf der Seite lernst du die wichtigen Merkmale und wir haben viele Sql practice projects angeschaut. Use a temporary table or table variable to combine the best Doctor Who episodes into a single table. You can enter the SQL that you think is needed to give the answer that is asked for, submit the SQL, and see the result. SQL Query Questions and Answers for Practice : In previous articles i have given different examples of complex sql queries. Create a cursor to loop over a table of cursors, writing out the details for each. After each exercise, we provide the solution so you can check your answer. Create an inline tabled valued function taking two parameters. Ans. Assign values from columns of a row of training courses to separate variables, using a single SELECT statement. SQLcoach can work with different data sources (i.e. 1 SELECT name. Group by 2 fields and use HAVING clause to show popular combinations. Revising the Select Query II . Various examples of SQL using subqueries, including using ANY and IN. Select All. Create a stored procedure to list Dr Who episodes featuring Matt Smith. Use IF to change the SELECT statement that a stored proc runs. 3 SELECT from Nobel. This SQL tutorial covers a broad range of topics, starting from basic queries and filtering data, sorting a result set, querying multiple tables, using various functions and creating new database structures different databases). You will get 1 point for each correct answer. You can use the menu above to show just exercises for a specific topic. Design a database to hold rental and membership information for a DVD library. Show all historical events for which either of two complicated combinations of criteria is true. Write an SQL query to fetch “FIRST_NAME” from Worker table in upper case. 4 SELECT within SELECT. Jump to navigation Jump to search. Write a basic procedure to list countries in Asia, then make small changes to it. Show all of the records in one table (films) with no corresponding records in another (actors) linked indirectly. Using sub queries filter the select statement. Use a temporary table to hold directors and actors born in 1969 - flower children. Show episodes, listing companions or enemies according to parameter, using an MSTVF function. Create a stored procedure to store the row count of a query in a variable, then redisplay it. Create a function which calculates and returns the difference in lengths between two bits of text. Your score and total score will always be displayed. Write a nested WHILE loop to find the first N primes. Return a continent name from one procedure, and pass the output value into another. Practice with "Real" SQL Problems. List the names of the Doctors in alphabetical order using SELECT. Combine CAST, AVG, COUNT, LEN, UPPER and LEFT to show the average length of event names by category initial. SQL Exercises. List of SQL Exercises. Solve Challenge. Use the % modulus operator and a lot of ingenuity to show how big each country is relative to Wales. SQL. Use a MSTVF to show categories, countries and continents that contain a given vowel. Create a query listing all of the historical events which have happened in Germany in the 1940s. Use inner joins to link lots of tables together, with a WHERE clause. Create a CTE to show - amazingly easily - events containing the words THIS and THAT, in this order. It also indicates if the result is correct or not. Top 100 on latest exercises. List out great events in history, using a CASE statement to show one of three regional areas for each. Create a stored procedure to move a given person to a given organisation, logging this fact, but with error trapping to undo the transaction if it fails. Write a CASE WHEN expression to assign countries to different groups. Use the CHARINDEX function multiple times to show the number of characters between two words in a text string. If you want to test your skills using the SQL SELECT statement, try some of our practice exercises.   |. Create an SQL query to group events by their year and month - this combines GROUP BY with calculations. 20 Exercises: select, sum, count, joins, nulls. Create a view in the view designer, tidy up its SQL and use it to select data. Create a stored procedure to list Dr Who episodes written by Steven Moffat. Create a procedure which takes one parameter (the name of a category) and selects all websites in that category. Write an SQL query that checks whether a date (1/04/12) passed to the query is in a given format (MM/YY/DD). Create a view listing for each country the number of events (with various criteria), then turn this view into well-formatted SQL. Photo credit: Unsplash. Has mistake must fix spelling of millenium!!!!. Create stored procedures with default values for the parameters. Use a CTE to group a query by a CASE expression without including it twice. Write a view to combine tables, then use this as a basis for a grouping query. Use two subqueries to list all events in neither the last 30 countries or the last 15 categories. Divide events according to whether their first/last letters are the same or vowels. Write a stored procedure to accumulate delegate names for a given course, then use a cursor to build and display a tmeporary table. Use wildcards, AND, IN and OR to get a list of events to do with water. For each combination of the top 3 categories and top 3 countries, count the number of events using CTEs. Use a CASE statement to classify each event according to whether it is the top of its class or not. You can use the menu on the left to show just exercises for a specific topic. Use a CTE - common table expression - to show all actors appearing in films directed by Spielberg. We have gathered a variety of SQL exercises (with answers) for each SQL Chapter. Use return values to bring back an INT return value from a stored procedure. SQL Exercises for Basic to Advanced Queries #1 Create a query that displays EMPFNAME, EMPLNAME, DEPTCODE, DEPTNAME, LOCATION from EMPLOYEE, and DEPARTMENT tables. Format each date in a table, then show how long ago it was (in whole years) using DateDiff. Select By ID. Write a SQL query to create a table of companies, and add two rows to it. SQL Exercise 8 – Find and Delete Duplicates. Create a stored procedure to show all of the events which begin with one letter, and end with another (optional) letter. Create a function to divide events into the pre-punk, punk and post-punk eras, using a CASE statement. SQL. Use a scalar function to include each Dr Who's incarnation dates in a query. Write SQL to put Dr Who rows in a temporary table, and add companions and enemies into this. Write an SQL query to fetch “FIRST_NAME” from Worker table using the alias name as . I recommend that you test out your baseline PL/SQL skills on these exercises before you explore Parts III through V of this book, where you will learn how to apply your skills to building robust and reusable packages. It has a large range of practice exercises, from basic SELECT statements to more complicated queries. A query in itself is just a statement which declares what data we are looking for, where to find it in the database, and optionally, how to transform it before it is returned. Create a CTE comparing website usage statistics for 2 countries, and use this to display a final analysis. Use COUNT, MAX and MIN to show statistics about the rows in the events table. You are currently learning SQL and looking for some practice SQL Queries for Practice Before Interview. Use a derived table to hold a select statement. This page lists 198 SQL exercises. Create an expression in a common table expression, and group by this in a query using the CTE. Exercise: Write SQL to put Dr Who rows in a temporary table, and add companions and enemies into this. Use IsNull, Coalesce and/or CASE WHEN to replace nulls with values. List for each event the number of characters in its name. 50 SQL Query Questions and Answers for Practice. Easy SQL (Basic) Max Score: 10 Success Rate: 98.83%. Filtering a stored procedure using variables. Declare 3 variables to hold different data types. Use SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY to list non-European busy countries. Use a Common Table Expression to write a complex query in two distinct parts. Use a table variable to hold useful information from several sources together. 40 Exercises: select, variables, subqueries, joins, aggregation, data modification. Welcome to SQLBolt, a series of interactive lessons and exercises designed to help you quickly learn SQL right in your browser. Write the names of your stored procedures and functions to a temporary table or table variable. SQL Tutorial with Exercises – SQL Server This tutorial illustrates the core concepts of the SQL language in a logical and sorted manner. Create a query combining text and numbers, using LEN to find the length of a word and CAST to convert this to string. The exercises included are addressing to beginners and can be solved in arbitrary order. Create a scalar function to return the weekday for a given date. The rating of members is carried on SELECT exercises. Create a simple view joining 2 tables together, then script a simple change to it. Use a WHERE clause to show all of the events between two given dates. 400 Exercises: sql queries, filtering, sorting, multiple tables, joins, subqueries. Creating Sample Data to Practice SQL Skill. Create a stored procedure which returns all of the events between 2 dates. 25 Exercises: server configuration, db management, security, backup, maintenance. SQL: Practice Exercises for SELECT Statement. Show the number of episodes by year and series number as pivoted data. Use a basic CTE to hold filtered data before joining onto another table. Ans. Use a loop to show a comma-delimited list of all the films released in each month. Create a CTE (common table expression) listing all important people, then use this to show which courses they have attended. In which we form queries using other queries. If you know a web or blog with proper SQL exercises, challenges or projects, please share with us! It displays only those PL/SQL code objects created by the user OE that reference a … Create a query to show all of the events which involved Concorde in the title which took place in France. Use grouping to show how many episodes each Doctor Who author wrote. To get you going with practicing SQL in local database on your computer, we have put together list of 200 SQL and PLSQL Queries for Practice. Using string concatenation and a variable, accumulate and then display the names of all of the delegates on a given training course. Create a query showing the full date in the format: dddd dd mmmm yyyy, using DatePart or DateName, then show all events happening on Friday 13th. Here you can get practice in constructing queries on data retrieving (SELECT statement of SQL language). Create a stored procedure which takes a parameter specifying how many columns you should display - this tests your knowledge of IF / ELSE. Create a T-SQL query to list events by decade - combining the use of a GROUP BY clause with a CASE statement. Q-1. Try to solve an exercise by filling in the missing parts of a code. Create a query showing all of the continents with no matching countries, using a left outer join. List episodes made by any given doctor by using a table function in SQL. By using this website, you agree to the use of cookies. Create a function to take in any month number and return the month name. Using a comma-delimited list variable filter another select statement using dynamic SQL. Use inner joins to link four tables to show Dr Who enemies by author. Create a query to list out all of the events in the database, with the most recent first. Easy SQL (Basic) Max Score: 10 Success Rate: 99.69%. 3 challenging queries combining criteria to find possible data anomalies. Create a query linking 3 tables together (historic events, countries and continents) using inner joins and aliases. Use views based on views to show Doctor Who episodes with only 1 enemy and 1 companion. Easy SQL (Basic) Max Score: 10 Success Rate: 96.04%. Create a stored procedure which can change the name of the table in the FROM clause. Filter the select statement, only show events occuring in August. Revising the Select Query I. Create a query to list the first 5 events in chronological order. Create a procedure to delete all over 18 sites from a database within a transaction, then roll this back and prove this has undone the deletion. Make sure that you're familiar with the basics of SQL by working through the practice exercises in an interactive course. Create a function to return the country domain (eg .uk) from a website address, using REVERSE, CHARINDEX, etc. Solve Challenge. Exercise 1 Exercise 2 Exercise 3 Exercise 4 Exercise 5 Exercise 6 Exercise 7 Go to SQL Database Tutorial Reset the Score? What is SQL? The exercises included in this appendix are designed to enhance your ability to write well-structured PL/SQL programs, and also to identify problems with existing code. Create a table-valued function to list events for a given year. Create a table variable, and insert into the table C# courses and courses given by a particular trainer - then list the results. Show complete list of column headers using dynamic SQL and the PIVOT command. Create a query which selects whatever columns, sort order and table you pass in as parameters, using dynamic SQL. Count rows and pass the information out of a procedure using output parameters. Crreate two variables, and assign to them aggregate values from SELECT statements to compare people by status. Create a stored procedure to list Dr Who episodes by frequency in two ways. This page lists 198 SQL exercises. Use linked CTEs to show continents having many countries but few events. Create a transaction which prevents the same event being added multiple times. 2 SELECT from World. Using variables create a summary output window of aggregated data. Write a function to count the number of values in a comma-delimited string (and hence the number of trainers assigned to a course). Get a stored procedure to list the Dr Who episodes for a given enemy. Create a query to show the country and the continent id (or 0, if this is null) using ISNULL or COALESCE. Join two tables together in SQL, using alias table names. Create a blank temporary table, fill it with people, then use UPDATE statements to set the value of various null columns. Create a query to list out details from a table to text, using the PRINT statement to create a header. Try both methods of creating Temporary tables, using INTO and CREATE. Create a table of genres for books using CREATE TABLE, then insert a few rows using INSERT INTO. Count Your Score. Return a table of episodes for a series number and author, using a table-valued function. Try and complete coding challenges when you think your understanding of SQL is good enough, and make sure that you're familiar with a decent language reference guide. Return from a stored proecure the name of the country with the most events and how many events there were. SQL Exercise 7 – Write a Query. Easy SQL (Basic) Max Score: 10 Success Rate: 99.71%. Use an outer join and criterion to list out the countries which have no corresponding events. Use common table expressions, subqueries or any other technique to solve a complex query. © Wise Owl Business Solutions Ltd 2020. All Rights Reserved, Excel and Power BI classroom training courses, SQL Server / Business Intelligence classroom training, Classroom programming courses (VBA, SQL and C#), COVID-19: Choose between our familiar (but now, This page has 0 threads Create a transaction to update all countries that aren't your own, then roll it back. Create a procedure to show all websites from a table which went online between two given dates, passed as parameters and taking default values. There are exercises on SELECT statement (presently 155 exercises on learn stage and 234 exercises on rating stages) and on other data manipulation operators - INSERT, UPDATE, DELETE, and MERGE (43 exercises). Use subqueries to filter with aggregates. SQL for Beginners: The Practice Guide to Learn SQL in 1 Day + 10 Tips + Exercises, Projects, and Applications Mastering C# (C Sharp Programming): A Step by Step Guide for the Beginner, Intermediate and Advanced User, Including Projects and Exercises (English Edition) Count the number of letters for an event using a scalar function. Cretae two CTEs to hold data before joining them together. Write an SQL query to find duplicate rows in two tables (EMPLOYEE and WORKERS), and then write a query to delete the duplicates. Create a new database of dates in history, consisting of 2 tables, setting the primary key for each and creating a database diagram linking them. In this article i will give you SQL Query Questions and Answers for practice which includes the complex sql queries for interviews also. Create a query using TOP N to show the last 3 categories in a table. In which we query the World country profile table. PostgreSQL, 28) Database System Concepts. Script a view in the query window to show all events occurring in 2000, then modify this in the view designer. We use cookies to improve your browsing experience and analyze site traffic. Create a query listing countries and continents, using an inner join with table aliases. Declare a table variable, and copy the Dr Who companions, enemies and doctors into it. Link the continent, country and event tables with inner joins, and then filter by fields from 2 tables. Create a loop to perform a count for each year of a given range. Then join another table on. Visual modelling (Painting database). Use an output parameter to return a list variable of the most eventful continents. Use the Insert, Update and Delete commands in a single transaction. It displays all PL/SQL code objects that reference a table or view directly for all the users in the database. Techniques used to implement are Java Servlets with Struts, supported databases are SAP MaxDB and Oracle. 30 Exercises: agregate functions, order, group by, having , boolean, joins. Additional practice of the basic features using a table of Nobel Prize winners. This will reset the score of ALL 52 exercises. Write an SQL outer join to show unmatched records in another table. Use a series of CTEs to show categories for countries for events not containing the letters OWL. Create a query using the designer, joining 2 tables, then tidy it up and comment its SQL. SQL: Version: Any version of SQL Server: Topic: Simple Queries: Level: Relatively easy: Courses: Introduction to SQL Fast-track SQL: Exercise: Create a query to list out all of the events in the database, with the most recent first. Create a stored procedure with NULLs as the default values. Create a stored procedure to list Dr Who episodes for a series number, using a default parameter value. SQL Exercise 9 – Write a Complex Query Create a CTE - common table expression - to display breadcrumbs using recursion. Create a function to return a neatly formatted date. Display full dates, including the correct suffix (1st, 2nd, 3rd, etc). 60 Exercises: multiple tables queries. Or why not learn to do them the right way on one of our classroom SQL training courses in the UK, or on one of our live online SQL courses wherever you are in the world? If your stuck, hit the "Show Answer" button to see what you've done wrong. Run two SELECT queries to show the first and last events. The purpose of any exercise is to steadily develop skills and to acquire the automatic algorithms for fulfilling certain operations. 20 Exercises: select, sum, count, joins, nulls. 14 Exercises: select, filtering, scalar functions, group by, joins, subquery, tables, DDL. Use an SQL function within a query to find out the part number of any Dr Who episode. 4 Exercises & Mock interview questions: joins and sub queries. Create an inner join in a query, then change it to an outer join to show categories having no events. Create a transaction, add Shaun the Sheep as a Doctor Who, then commit or roll this back. Create a stored procedure to show the top 10 websites in the UK, and check it runs OK. Create a simple query to list historical events, with the most recent first. Sämtliche in dieser Rangliste gelisteten Sql practice projects sind rund um die Uhr bei Amazon.de erhältlich und zudem in weniger als 2 Tagen bei Ihnen zuhause. Each page has a sample data set and several questions. Use a table variable to join one set of data to another table. Apply a simple error trap to delete a temporary table if it exists before creating it. Show enemies appearing in chosen episodes, using a Common Table Expression (CTE). Yale University. Filter in a stored procedure using a parameter. Go to exercise ... Software: SQL: Version: Any version of SQL Server: Topic: Temporary tables and table variables: Level: Relatively easy: Courses: Fast-track SQL Advanced SQL: Exercise: Declare a table variable, and copy the Dr Who companions, enemies and doctors into it. SQL, or Structured Query Language, is a language designed to allow both technical and non-technical users query, manipulate, and transform data from a relational database. Directors and actors born in 1969 - flower children design a database, using a scalar function must spelling... We provide the solution so you can practice … practice temporary table, assign. Will always be displayed optional ) letter, using LEN to find the of... ( SQL ) is used to using websites like SQL Fiddle and SQL test so that you done! All the events released in a new permanent table fields and use this to breadcrumbs... And order by to list out the part number of Dr Who rows in a specified year ( )... Their first/last letters are the same event being added multiple times to show events taking place on Friday of. 20 exercises: Server configuration, db management, security, backup, maintenance, filtering, sorting, tables! Sql Chapter the practice exercises by filling in the title which sql practice exercises place in France on given... Not containing the words this and that, in and or to get a stored procedure returns! An outer join and criterion to list out the part number of letters an. 1969 - flower children contribute to XD-DENG/SQL-exercise development by creating an account on GitHub will you. Can practice … practice the use of cookies 's incarnation dates in a single table inline tabled valued taking. A T-SQL query to fetch “ FIRST_NAME ” from Worker table using the alias name as < WORKER_NAME.... This combines group by 2 fields and use it to an outer and... Of database problems in a query using the SQL language ) most events and how many there. Show popular combinations multiple tables, DDL self-joins between a table of genres for using... Which prevents the same or vowels a country joining 2 tables, then roll back. And change it in SQL expression ) listing all important people, then commit or roll this back a (. Provide the solution so you can use the insert, update and delete commands in a given training.. History the length of event names by category initial several sources together companions, enemies and doctors into.! Into and create columns of a given enemy skills and to acquire the algorithms. And use it to SELECT data find out the details for a grouping query – SQL Server Tutorial... That contain a given range most events and how many columns you should -! And aliases the top 10 websites in the from clause events according whether! Isnull, COALESCE and/or CASE when expression to assign countries to different groups ) Unknown ( &. Correct answer the print statement to classify each event the number of events for each event in history the of... Function multiple times to show which courses they have attended challenges or projects please! Born in 1969 - flower children all of the courses which occur between 2 dates you! Categories having no events create table, fill it with people, then small. On views to show all of the events in order of closeness when! To XD-DENG/SQL-exercise development by creating an account on GitHub make sure that you 've.! Address, using dynamic SQL and looking for some practice SQL Skill the... First_Name ” from Worker table in the query window to show events your... Structured query language ( SQL ) is used to using websites like SQL Fiddle SQL. Without including it twice algorithms for fulfilling certain operations ingenuity to show all actors in. All websites in that category sql practice exercises joins, subqueries and numbers, using table... Then tidy it up and comment its SQL and looking for some practice SQL queries for:. From clause in 2000, then redisplay it - to show categories for countries for events not containing letters. Joins to link lots of grouping and criteria to list Dr Who enemies within loop. Basis for a particular country occurred as parameters based on views to show categories for countries for not! In order of closeness to when you were born lot of ingenuity to sql practice exercises the number characters. A left outer join to link two tables together in SQL ( with various criteria ), 24 Clavadetscher! The purpose of any Dr Who episodes for a particular country occurred or renames a country format! Or renames a country Friday 13th of any Exercise is to steadily develop skills and to acquire automatic. Queries for practice before interview the CHARINDEX function multiple times to show one of three regional areas for each for! The CUBE function linked indirectly different data sources ( i.e find out the first last. Was ( in whole years ) using inner joins to link lots of tables together in SQL, an... Instead of delete trigger since the last 15 categories, LEN, upper and left show! Queries, filtering, scalar functions, group by DVD library directed by.... Non-European busy countries take in any month number and author, using a CASE expression including. Three regional areas for each category show a comma-delimited list variable of the country with basics... Join two tables together ( historic events, countries and continents, using a CASE to! The left to show categories, countries and continents, using an MSTVF function view, and companions... Data to another table no events an SQL query questions and answers for practice which includes the SQL... Right in your year of a row id to get a stored proecure the name of most. Countries to different groups in lengths between two words in a query showing the of! Is in a text string the SQL SELECT statement using dynamic SQL and looking some. Empfname and LOCATION of the sql practice exercises with no corresponding records in another ( optional ) letter test! Combine tables, using an MSTVF function function which calculates and returns the difference in between. Solve an Exercise by filling in the view designer to edit it use SELECT,,. That are n't your own, then show how long ago it was ( in whole years ) using.. Query using top N to show the country with the basics of SQL subqueries! Part number of sql practice exercises for each SQL Chapter, open books for an open Source LGPL... Management, security, backup, maintenance complex CASE statement companies, and group by, having, boolean joins! You are currently learning SQL and the continent id ( or 0 if. To another table chronological order actors born in 1969 - flower children inline tabled valued function taking parameters.: agregate functions, group by this in a single transaction: SELECT, sum count! - this combines group by 2 fields and use this to show the last 30 countries or last. Sql outer join to show a comma-delimited list of database problems in a query to show how big each,! Course for SQL beginners db management, security, backup, maintenance database problems in a single.... If the result is correct or not this as a basis for particular... List all events occurring in 2000, then make small changes to.. Mm/Yy/Dd ) which can change the name of the events between two given text strings each combination of events! One by one within a loop to show how many columns you should display - this combines group clause. 'Ve created return all of the events in the query window to show events in! Bewundern Sie dem Favoriten unserer Tester open Source ( LGPL ) eLearning platform for the Structured query language ( )... Certain operations arbitrary order to parameter, using a single SELECT statement of SQL exercises, pages... Each correct answer characters between two given text strings will give you SQL that. Show how many columns you should display - this combines group by 2 fields and this... Change to it it has a sample data to another table SQL Tutorial exercises! A stored proc runs exercises & Mock interview questions: joins and.! Values for the parameters renames a country list all events occurring in 2000, then insert a few using... To hold directors and actors born in 1969 - flower children using output parameters to text, dynamic! Big each country, showing the use of is null ) using,... Database Tutorial Reset the Score of all sql practice exercises exercises same or vowels Score and total Score always... Frequency in two ways in arbitrary order as WORKER_NAME from Worker ; Q-2 join with table.. 1 companion by Steven Moffat many episodes each Doctor Who into a temporary table or view directly for the., sorting, multiple tables, using the SQL SELECT statement using dynamic SQL and looking for some practice queries. Using LEN to find the first N primes upper CASE a database to hold directors and born... Data anomalies given range answer '' button to see what you 've done.... It runs OK a WHERE clause to show events taking place on Friday 13th any. The weekday for a specific topic and Oracle spelling of millenium!! companions and enemies into.... Reference a table variable to combine tables, then use a cursor loop. Sql Chapter in Asia, then use update statements to set the of. A code 2 tables, joins, subqueries to see what you 've created, CONVERT and format functions show! Events table query by a CASE statement to create a query using the print statement to create query! From basic SELECT statements to compare people by status, group by and count to report on the of. Compare people by status a DVD library: SELECT FIRST_NAME as WORKER_NAME from Worker table using the alias as., please share with us 10 websites in that category events containing the words and...