Answer:
the two on the bottom and the two on the top
Explanation:
move the two on the bottom apart and the two on the top inward
Answer:
I am writing a Python program that deletes players from the file whose names whose names do not begin with a vowel which means their names begin with a consonant instead. Since the SomePlayers.txt is not provided so i am creating this file. You can simply use this program on your own file.
fileobj= open('SomePlayers.txt', 'r')
player_names=[name.rstrip() for name in fileobj]
fileobj.close()
vowels = ('a', 'e', 'i', 'o', 'u','A','E','I','O','U')
player_names=[name for name in player_names
if name[0] in vowels]
fileobj.close()
print(player_names)
Explanation:
I will explain the program line by line.
First SomePlayers.txt is opened in r mode which is read mode using open() method. fileobj is the name of the file object created to access or manipulate the SomePlayers.txt file. Next a for loop is used to move through each string in the text file and rstrip() method is used to remove white spaces from the text file and stores the names in player_names. Next the file is closed using close() method. Next vowels holds the list of characters which are vowels including both the upper and lower case vowels.
player_names=[name for name in player_names
if name[0] in vowels]
This is the main line of the code. The for loop traverses through every name string in the text file SomePlayers.txt which was first stored in player_names when rstrip() method was used. Now the IF condition checks the first character of each name string. [0] is the index position of the first character of each players name. So the if condition checks if the first character of the name is a vowel or not. in keyword is used here to check if the vowel is included in the first character of every name in the file. This will separate all the names that begins with a vowel and stores in the list player_names. At the end the print statement print(player_names) displays all the names included in the player_names which begin with a vowel hence removing all those names do not begin with a vowel.
Answer:
The above query gives an error.
Explanation:
- The query gives an error because is not the correct syntax of the select or inserts query.
- The syntax of the select query is as follows: "select Attributes_1_name, Attributes_2_name,...., Attributes_n_name from table_name;".
- The syntax of the insert query is : "insert into table_name (column_1_name, column_2_name,...,column_n_name) values (column_1_value, column_2_value,...,column_n_value);".
- The syntax of the insert and select query is : "insert into table_name (select Attributes_1_name, Attributes_2_name,...., Attributes_n_name from table_name);".
- But the above query does not satisfy any property which is defined above. Hence it gives a compile-time error.