Ask VF masters, VF masters, help, help.

-- First, select the table, assuming that the table name is studentselect students

14. Use each student's three grades to calculate their average score and fill in the table.

replace all average score with (math + computer + English) 3--15: For all students who are party members, the average score will be increased by 10% on the basis of the original average score replace the average score with average score * for league members.

Sixteen: Tombstone-detombing all female classmates.

delete for alltrim(gender)='Female'

Seventeen: Show all student records whose names are 3 words.

display for lenc (name) = 3 -- eighteen: displays the records of all classmates born in September.

display for month = 9 - 19: Displays the records of all students over the age of 25.

display for year(date)-year(date of birth)>=25

repl all average score with (math + computer + English) 3repl average score with average score* for group members.

dele for gender='Female'

list for len(allt(name)) = 6list for month = 9list for year(date())year(year)>25

display student number, name, place of origin for party member=.t.and month (date of birth) >6

for the inside. t.You can't add quotation marks, and if you add quotation marks, it's not logical, but characteristic.

1) Enter modi command cx12) in the command window.

set talk off

s=0for i=1 to 1000

if i%2=0

s=s+iendif

endfor

The sum of even numbers within 1-1000 is:",s

set talk on

3) Press Ctrl+S to save, press Ctrl+E to run.

Really, as long as you save it, you will get points.

Here's the answer:

The first problem: want to get it from the repository. In dbf, querying warehouse information in the city of Beijing and Shanghai is a logical or operation (or), and it is a condition that has the meaning and is used only (and operation), so the correct statement:

select * from warehouse where city='Beijing'or City'Shanghai'

The second question: from the ** quotient. In DBF, query all the business information of the company name containing the word electron. Correct statement:

select * from **quotient where name like'%electron%'Instead of select * from **quotient where name="%electro%".

This is because the wildcard character "%" is not supported after the " in the conditional statement in SQL, and the condition is not followed by double quotation marks but single quotation marks in English.

The third question: from **. There are no duplicates in DBF to display all ** trade names; Correct statement:

select distinct **Trade name from **.

1.select * from warehouse where city='Beijing'or City'Shanghai'

2.= refers to the first name, and this field is exactly equal to. If the name ='%electron%'

Then it means that the name is'%electron%'of course, there is no like will recognize the keyword %. is the concept of fuzzy query 3select distinct **trade name from **business.