concert | Concert is a console based certificate generation tool | TLS library

I have next table :

I am trying to write a query that will return the number of orders placed during on sales-date vs on non-on sales date for each event in my Event Table.

Orders Table

Event Table

The Ouput Table should be Something like

My current Query that I have so far is:

I want to get 20 most common words from the descriptions of top 10 longest movies from data.csv, by using Python. So far, I got top 10 longest movies, however I am unable to get most common words from those specific movies, my code just gives most common words from whole data.csv itself. I tried Counter, Pandas, Numpy, Mathlib, but I have no idea how to make Python look exactly for most common words in the specific rows and column (description of movies) of the data table

My code:

I'm working on this sql challenge, but I don't know if the way to get the top 1% of soloists calculated by the total number of concerts performed. is correct. Please help me, thank you. Below are the challenge and my code.

1. Orchestra Celebration

The New York Philharmonic is one of America's largest orchestras. In honor of its many famous musicians, the director is planning a special event. She wants to hold a concert to celebrate the top soloists from its history. You have been asked to determine which soloists should receive recognition.The director has given you the following requirements:

• The results should only include the top 1% of soloists calculated by the total number of concerts performed.

• Limit your results to entries where the orchestra is 'New York Philharmonic' and the event type is 'Subscription Season'. Soloist performances in other orchestras or event types should not count towards the calculation of the top soloists.

• The director is only interested in individual soloists. You will need to exclude all of the following soloists: 'Chorus', 'No Soloist', 'New York Choral Artists', and 'Schola Cantorum of NY'. You should
  also exclude any soloist with 'choir' in the name.

Your result should contain the following columns. It should meet all requirements as described.

column requirements

1. name The name of the soloist, with the first name followed by the last name (e.g., Jane Smith). Please note that in the soloists table, names are in reverse order (last name, first name).
2. first_date The first date the soloist ever performed with the orchestra, in the format '01 Jan 2015' (i.e., month as an integer, short month name, and year as an integer).
3. last_date The last date the soloist ever performed with the orchestra, in the format '01 Jan 2015' (i.e., month as an integer, short month name, and year as an integer).
4. total_concerts The total number of concerts the soloist performed.

Order your results by the total number of concerts performed in descending order, and then by soloist name in alphabetical order. The data you will need is available in the two tables detailed in the schema below. This is a picture of the schema This is the dataset

Below is my code and I don't know where I'm wrong, please help me, thank you all in advance

I have two hash, first one %hash contain uniq key and values.

The other one %channel contain only the Stores which are already present as values from %hash

I would like to display all the Category id (for example Category::1375567 etc..) which refer to the Store (for example Store::CAR)

Here below the expected result of what I need, it will be more efficient than my explication.

Using Rational Team Concert (aka Jazz source control), when loading a new repository workspace to a sandbox I am encountering error CRRTC8550E, and the resulting sandbox is incomplete. I am using Windows 10, Visual Studio 19 and the RTC plug-in for Visual Studio (6.0.6.1).

I'm using asyncio in concert with the httpx.AsyncClient for the first time and trying to figure out how to complete my list of tasks when some number of them may fail. I'm using a pattern I found in a few places where I populate an asyncio Queue with coroutine functions, and have a set of workers process that queue from inside asyncio.gather. Normally, if the function doing the work raises an exception, you'll see the whole script just fail during that processing, and report the exception along with a RuntimeWarning: coroutine foo was never awaited, indicating that you never finished your list.

I found the return_exceptions option for asyncio.gather, and that has helped, but not completely. my script will still die after I've gotten the exception the same number of times as the total number of workers that I've thrown into my call to gather. The following is a simple script that demonstrates the problem.

So I had a programming competition ,I was stuck in a question and I trying to solve it these few days. because I want to know the answer so much, but I'm not able to do it. Any explanation or answer will be appreciated. Here is the question:

There’s a concert happening at a Hall. The hall is an infinitely long 1D number line, where each of the N students are standing at a certain point in the number line. Since they are all scattered around different positions in the number line, its getting harder to manage them. So the organizer Kyle wants to move them in the hall in such a way so that they all are in consecutive positions, for example, they are in positions 2,3,4,5 instead of being scattered around like 1,3,5,6. In simpler words, there is no gap between them. At one time Kyle can pick one person who is on the most outer positions on any side. For example in 1,3,5,6 the most outer positions are 1 and 6. He can pick either of them and move them to any unoccupied position so that they are not in the most outer position anymore. This makes them come closer and closer with each move until they are all in consecutive positions. Find the maximum and minimum number of moves that can accomplish this task.

I have this local JSON File, which contains title, start and end. I want to create dates from the start and end keys, but a String for the title, so I can create Event objects. Right now I have decoded everything into Strings. So I'm trying to create a custom init, but an error keeps showing up "Return from initializer without initializing all stored properties". Not sure what am I doing wrong

Here's my Event model and my JSONFile