Entry level data analyst interview questions jobs
I am in need of an experienced SQL database administrator to help me move an entire SQL database from one server to another. The new server has Windows Server 2012 R2 installed and the SQL software is up and running. However, I am unsuccessful in attempting to access this via the network. Key Tasks: - Transfer the entire SQL database to a new server - Setup proper net...from the source server on the new server Ideal Skills: - Rich experience with SQL and Windows Server 2012 R2 - Understanding of maintaining active operations during server shift - Firewall setup and operations Security isn't to be compromised during this relocation. The current server has a firewall in place for the SQL database that requires careful handling. The new server needs the same level of security...
I am in need of a skilled professional who can help me create schematic diagrams for educational purposes. The work will involve: - **Creating Schematic Diagrams**: I need help with creating Schematic Diagrams for educational purposes that would give a basic overview of the system with major components. - **Detailing**: The level of detail required is to provide an overview and include major components. Detailed component specifications and values are not necessary. Ideal candidate for this project: - **Electrical Engineering Background**: You should have a strong background in electrical engineering to accurately depict the systems and components in the schematic diagrams. - **Experience in Creating Schematic Diagrams**: Prior experience in creating schematic diagrams is a plus....
App updates with these issues will be rejected App must target Android 13 (API level 33) or higher Enforced Aug 30, 2023 Warning sent Aug 10, 2023
As an IT c...initial setup and account creation for new customers. This includes ensuring that the account is properly configured and the customer receives necessary information to get started. - Ongoing Support and Follow-up: Your role doesn't end at onboarding. We need you to maintain an open line of communication with clients, ensuring they're satisfied with our services. This includes answering their questions and providing necessary guidance. Ideal candidate: - Native Italian speaker with fluent English - Experience in customer service and account management - Strong communication and problem-solving skills - Familiarity with IT or tech industry is a plus Your role is crucial in maintaining positive client relationships and ensuring their needs are met in a timely a...
...for applying to be a tutor on our platform or charge a registration fee. -- NOTE: this position does not currently provide Paid Leave, Health Insurance, Retirement Programs, or other employee allowances. ROLE RESPONSIBILITES -- Conduct engaging and interactive online tutoring sessions for K-12 students within designated hours through personalised learning plans based on students' grade level, needs, and academic goals. -- Utilise diverse online instructional strategies, tools, and resources to create an interactive and stimulating learning experience, adapting when necessary to drive student growth. -- Provide clear and effective instruction, guidance, and feedback to enhance students' comprehension and to inform future tutoring sessions. -- Maintain ...
THIS IS NOT A BUSINESS ANALYSIS FROM THE PERSPECTIVE OF BUSINESS VALUATION OR FINANCE. THIS IS A REQUIREMENT GATHERING AND FINALIZATION FOR LEAD CAPTURE PAGES. It is a small proejct. I have a few lead capture pages to be designed and I need your expertise in developing the requirements, process mapping, wireframing, and possible test cases. It is not a large project but it does have a few variants of lead capture processes.
...primary school level maths questions based on the specific skills required to answer them correctly. The task will be to review 50 past papers - containing approx 50 questions each. For each question, I need someone to: - cut & paste an image of the question into a Google slides / Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page number of Google Slides document that the question appears on Key Requirements: - The questions ar...
As a passionate advocate for education, I am seeking a talented freelancer experienced in teaching language arts, particularly focused on enhancing vocabulary, word choice, presentation...their vocabulary and improving their presentation skills. - Multifaceted Approach: I am looking for a versatile tutor who can provide help using a variety of methods. This should include online tutoring sessions, creating interactive video tutorials, and providing written feedback on their assignments. - Required Experience: Previous experience in teaching English language arts at middle school level would be a definite plus. Bulls-eye would be someone who is patient, understanding, and knows how to engage young learners. If you are passionate about teaching and believe in making a difference, l...
I'm looking for someone who can help me identify and find the owners of commercial properties in London. Key R...properties in London. Key Responsibilities: - Research and identify owners of a specified list of commercial properties in London - Compile data on the owners and their contact information in a spreadsheet The ideal freelancer for this project would have: - Strong research skills, especially in identifying ownership of commercial properties - Experience in data entry and management, particularly in spreadsheet format - High level of accuracy and attention to detail - Excellent communication skills, as you may need to verify information Please provide a brief overview of your experience in identifying property owners, and any relevant experi...
I already hired one person for this position but work is increasing so I am looking for a second one. A plus if you can do video editing or graphic design. I need a fully bilingual professional (I will interview in English via video) to do some tasks for my agency, such as: Social media Content editing or creating CRM management Email marketing Writing an ebook Researching Organizing data in spreadsheets Copywriting Basic Wordpress (change text, add a button, upload a file, etc) And others related to the position You must be a FAST learner, attentive to details, curious, with great writing skills. Looking for someone that pays attention and doesn’t keep making the same mistakes over and over. Attention to detail. Common sense. This job will part-time as a te...
I'm seeking a skilled Adobe Launch tutor who can assist me in a few specific areas. Details: - I have an intermediate level of proficiency in Adobe Launch and am aiming to offer services in this area in the future. - I'm particularly interested in being tutored in standard implementations, custom JavaScript, ecommerce, and working with single page applications. Ideal Skills and Experience: - Proficiency in Adobe Launch at an advanced level. - Prior experience in tutoring or teaching Adobe Launch is highly beneficial. - Strong understanding of standard implementations, custom JavaScript, ecommerce, and single page applications is essential.
I am looking for an independent contractor to create and manage Facebook ads for my agency. My Agency, Millionix, works only with plastic and cosmetic surgeons. So i need an experienced Media Buyer that can generate leads steadily through Facebook ads. The Media Buyer also needs to be able to create landing pages for Lead Reactivation. A good level of English is a must. And i need proof of work. Everything else will be discussed on an Interview, at the third phase of this hiring process. Looking forward to your applications.
I'm starting a new company, RC Construction and Hydraulics LLC, a home renovation and hydraulic repair company. I need a logo that conveys strength, reliability, efficiency, simplicity, expertise and trustworthiness. I'll be using this logo across various platforms, including our website, social media, printed materials like business cards and brochures, and physical product...brochures, and physical products or packaging. The logo is to be designed using the color palette: Brown #8B4513, Steel Blue #4682B4, Slate Gray #708090, Dark Olive Green #556B2F, and Light Gray #556B2F. The typography should consist of the Header Font: Roboto Condensed and Body Font: Open Sans. But open to creative input regarding font type. FINAL FILES IN PNG & PSD. Feel free to ask any questio...
I'm seeking skilled virtual business development officers who can help take my Extrusion Die Manufacturing business to the next level. Key Responsibilities: - Lead Generation: Your primary duty will be to find and attract potential clients in the technology and manufacturing sectors. - Sales Calls and Follow-ups: Once you've identified leads, you will be responsible for making initial sales calls and following up on leads. - Proposal and Contract Negotiation: Your role will also involve drafting proposals and negotiating contracts with potential clients. Ideal Candidate: - Previous Experience: A background in business development, especially in the manufacturing industry, will be highly beneficial. - Communication Skills: Strong verbal and written communication skills ar...
I'm seeking a talented React JS developer to help fix some UI and functionality issues in my project. The bugs are more on the intermediate level, involving the malfunctioning of certain features. Key Tasks: - Identify and diagnose the existing issues in the UI - Fix the functionality problems that are impairing the user experience The ideal candidate must have: - Proven experience in React JS development - Strong problem-solving skills - A proactive attitude in identifying and resolving bugs - Previous experience in debugging intermediate level issues Please include your experience in your application, and ideally, some examples of past work where you've dealt with similar bugs.
...maintaining data integrity. - API Integration: The application will interface with external systems through APIs. Your role will involve seamless integration. Frontend Developer Tasks: - JavaScript Development: Your JavaScript expertise will be crucial in building interactive and responsive user interfaces. - React Development: You will be working with React to create dynamic, efficient, and scalable frontend components. - User Interface Design: An eye for design and user experience is essential. You'll be responsible for creating an intuitive and appealing interface. The main purpose of this project is to build a sophisticated web payment application from the ground up. The successful team will need to communicate effectively, work well together, and demonstrate a high ...
I'm looking for an experienced developer to create an AI customer service chatbot for my business. You will be using OpenAi api. You will need to extract all email from our gmail account to train the model. The model should be able to create response to customer queries using the training data. This will be a chrome extensions. The primary functionality I need is for it to be able to effectively respond to frequently asked questions (FAQs). Key Project Details: - Platform: The chatbot should be developed specifically for my business - Functionality: The primary function of the chatbot should be to accurately answer customer's FAQs. - Language Support: I am not sure if multiple languages will be required at this stage, but the ability to add this in the futur...
I have a sizable amount of numeric data that needs to be inputted from handwritten documents. This is a meticulous task that requires attention to detail as the data must be entered accurately. Key tasks include: - Transcribing data from handwritten documents into a digital format. - Ensuring the data is accurate during the entry process. Skills/Experience required: - Proficient in data entry, especially numeric data. - High level of accuracy and attention to detail. - Previous experience with handwritten document data entry is preferred. - Understanding and application of data validation techniques.
I need a skilled graphic designer to create top-notch marketing materials for print. The focus will be on brochures, posters, and banners. The ideal freelancer for this project would have a combination of the following abilities and experience: - Proficiency in Adobe Suite or equivalent graphic design so...understanding of the unique considerations of print design, such as resolution and color matching - Ability to bring creative and innovative design ideas - Demonstrable experience in working within brand guidelines - Strong communication skills to ensure the project’s objectives are met. Previous work in designing print marketing materials will be highly valued. This project requires a high level of creativity, attention to detail, and an understanding of effective mark...
As an Airbnb host, I am in search of a reliable, proficient, and a consistently available professional to handle: - **Guest Complaint Resolution**: An essential part of this role is dealing with and resolving guest complaints. You'll need exceptional communication and problem-solving skil...promptly to guest reviews and obtain the ability to remove negative feedbacks. The ideal candidate for this position will have substantial experience in customer service or a related field, preferably with exposure to the Airbnb platform or similar holiday rental platforms. Competence in written communication and a high level of diplomacy are also required. This position demands a keen individual who can swiftly adapt to changing situations while maintaining a high level of professi...
I have a set of handwritten documents that are moderately clear and need to be typed out without any changes in the format. I am looking for an experienced typist or data entry specialist for this project. The successful candidate should: - Have a strong proficiency in English - Be able to decipher moderately clear handwriting - Be patient and detail-oriented The task is to accurately transcribe the content of the handwritten pages into a digital document, without any alterations in the layout. Your responsibility is to provide me with a neatly typed, error-free version of the original handwritten text. Please note that the quality of the output will be checked against the original, hence, accuracy is paramount.
...booking bot to enhance our Go High Level platform. The bot should be capable of performing tasks autonomously, specifically: - Managing bookings: The bot should effortlessly handle our booking system, including the ability to schedule appointments, manage cancellations and handle changes to existing bookings. This must not be done by simply sending a booking link - we've tried this and adherence is poor. Appointments must be booked as though speaking to a human via text message. - Customer support: Additionally, the bot should be capable of engaging with customers, answering commonly asked questions, and providing general customer support to enhance our user's experience. Key skills for the job include: - Extensive experience with Go High Level ...
The purpose of this report is to propose the system analysis for the client, with the intention of ensuring all stakeholders involved agree to the planned solution. Throughout the project the analysis, development, implementation and testing phases will be conducted using the industry standard, agile development life cycle. This specifies that changes can be made if required and appropriate. The system analysis report is intended for all the project’s major stakeholders: the client, the trainers, the costumers ,if they can be involved, and the development team.
I am in need of a professional data entry specialist able to handle a variety of data types and formats. This includes text, numbers, and images, with the bulk of the work being in Excel format, but also involving Word and PDF files. The task involves inputting a small amount of data, less than 100 entries. Ideal Skills and Experience: - Proven experience in data entry, ideally with a variety of data types - Expertise in Excel, with the ability to organize and manage data effectively - Attention to detail to ensure accurate data entry - Time management skills to complete the task efficiently - Familiarity with Word and PDF formats Your precision and understanding of various data formats will be key in executing...
I require a comprehensive business plan, our primary goal being defining our business strategies. We also aim to develop an impressive company portfolio highlighting key elements. This project will demand strategic thinking, proficient ...Key responsibilities would include: - Devising strategic business plans - Emphasizing our relationships with major brands (Brand A, Brand B, Brand C) - Detailing our revenue from the previous year and projections for the next Ideal candidate would come with solid experience in creating business plans and compiling outstanding company portfolios. Having industry contacts would be a plus. Expert-level understanding of the market dynamics, financial modeling, and strategic planning is critical for this role. Previous work with renowned brands will ...
Data entry for horse racing from a public website
I am in need of a skilled French Canadian translator to convert my short...terminology or jargon. Key points: - The translation must maintain the essence and tone of the original content. - It should be culturally relevant and appealing to a French Canadian audience. - Attention to detail is crucial to ensure a seamless and professional print publication. Ideal skills and experience: - Proven experience in translation, particularly for print publications. - Native-level fluency in French Canadian. - A good understanding of English and the ability to maintain the original content's essence and tone. - Experience in literary translation would be a bonus. If you meet these criteria and are confident in your ability to deliver high-quality print-ready translations, I'd lo...
Hi, I am a political science student and I am considering conducting research regarding formal documents' verification services in different countries, focusing on notary and apostille signatures. I am looking for someone who recently went through the process of notarizing documents in the EU, who can answer some basic questions regarding the process. Thank you for contacting me!
I need help with data entry and formatting for a Google Sheet. The data is to be sourced from ONLY 1 Website. Key Tasks: - Copy-pasting text information and images or screenshots from Website 1 into a Google Sheet. - Formatting the data in the Google Sheet with columns and tables. Ideal Skills: - Proficiency in data entry, specifically with Google Sheets. - Strong attention to detail to ensure accuracy and completeness of the data. - Ability to organize data efficiently using columns and tables along with images etc for capturing the User flow in a tree form . Example the website has Question 1 and N number of responses. Based on the responses there are different questions based on the responses. Need to capture that in ...
I am looking for an advanced level Grasshopper expert who can assist me in automating design complexity in Rhino. Your tasks include, but not limited to: - Scripting and Automation: Crafting custom scripts for efficient architectural model creation and routine task automation. - Parametric Design: Generating fluid and flexible architectural designs based on various parameters. - Algorithmic Modeling: Conceiving robust algorithms to represent and signal complexities in 3D models. Ideal candidates have in-depth experience with Grasshopper in Rhino environments and can demonstrate their expertise in advanced scripting, parametric design, and algorithmic modeling. Understanding complex CAD design principles and the ability to troubleshoot under pressure would also be beneficial.
I'm searching for a senior-level accountant to manage a range of accounting tasks for my business. Key responsibilities include: - Expertise in bookkeeping, tax preparation and financial statement analysis - Handling all the accounting aspects with precision and accuracy - Providing regular financial updates and reports - Ensuring all the accounting practices are in line with the latest regulations Ideal candidates should have: - Proven track record in senior accounting roles - Extensive experience in bookkeeping, tax preparation, and financial statement analysis - Ability to communicate effectively through email - Strong organizational and analytical skills - Up-to-date knowledge of accounting laws and regulations - Professional accounting certification(s) is a plus Your r...
I require a data entry specialist who can assist with online data entry work. The data is sourced from websites and needs to be input into Word documents. Key Responsibilities: - Accurately transcribing data from websites into Word documents - Ensuring the data is organized and structured according to specific guidelines Ideal Skills and Experience: - Proficiency in data entry - Excellent typing and accuracy skills - Familiarity with web research - Experience with organizing data in Word documents Please note that attention to detail is crucial for this job, as the accuracy of the transcribed data is of utmost importance.
I have a Microsoft Word Form document (tables filling 2 pages) that I'd like converted into a webpage form that users can interact with. The form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word
I'm looking for a talented writer to create a children's book targeted at preschoolers (ages 3-5). The key message I want to convey is about the importance of inclusivity and kindness towards others. Key Points: - Target Audience: The book is aimed at preschoolers, so the language, tone and story complexity should be suitable for this age group. - Theme: The central theme should revolve around inclusiveness and kindness. - Character: I want the story to be told through children as characters. This will help young readers relate to the story better and understand the importance of the message. I'm looking for a writer who has experience in writing children's books, especially for the preschool age group. It's important that the language is simple, engaging and ag...
I'm seeking a beginner level IT Technical Trainer with expertise in Networking, Operating Systems Trouble Shooting, and MDM. The candidate I'm looking for should have: - Solid foundation in Networking - Knowledge of MDM (Mobile Device Management) - Ability to troubleshoot various operating systems The mode of training delivery preferred is in-person at our location. Therefore, local candidates or those willing to commute will be ideal.
I'm on the hunt for a talented designer...Progress tracker which includes tracking for belts, stripes, seminars, competition history - Sections for gratitude, mindfulness, wellbeing, and meditation challenges - Pages with inspirational quotes - Blank pages filled with key questions and prompts about jiu jitsu eg: What are your short, medium and long term SMART goals. What does jiujitsu mean to you? Why should you compete? What lessons do you learn that are transferable to every day life? - sections with tips surrounding training, lifestyle, nutrition and mental health The ideal candidate should be a high level practitioner with strong knowledge of jiujitsu, previous experience with sport journal design, and a creative outlook to include both the technical and spiritual ...
I need a detail-oriented freelancer to help me transfer data from various PDF files. Key Responsibilities: - Copy and paste data from PDF files to other formats. - Ensure data integrity and accuracy. - Work efficiently without compromising quality. Ideal Candidate: - Proficient in using PDF files - Strong attention to detail - Previous experience with data entry/copy-paste tasks - Ability to work under time constraints Looking forward to your proposals.
I'm in need of an experienced VBA d...efficiency within the software. Key requirements: - Proficient in VBA: You should be well-versed in VBA programming and have a proven track record of creating efficient and effective macros. - Microsoft Excel expertise: Experience in working extensively with Excel is a must. - Automation focus: The macros need to automate a variety of tasks, including data entry, report generation, and potentially formatting. While the complexity of the data manipulation needed isn't explicitly detailed, please be prepared to work on tasks ranging from basic calculations to more intermediate or even advanced functions. Your ability to adapt to varying complexity levels and your experience in integrating different functions will be key i...
I require data entry services targeting both English and Malayalam languages for a medium volume of content sourced from digital files. As such, potential bidders should have the following: - Proficiency in written Malayalam and English to ensure accurate and efficient data entry. - Basic IT skills to navigate and extract data from digital files. - Attention to detail, ensuring data is properly entered without errors. - Experience in the field of data entry, especially if done in multiple languages. Your role will primarily involve transferring data from digital files into our designated format. Please state any relevant experiences or skills in your bid.
...looking for a backend developer who has proficient skills in MongoDB, , React.js and Node.js, colloquially known as the MERN stack. Key Requirements: - Substantial experience using the MERN stack for backend development. - Proven record of delivering robust, error-free applications using these technologies. - Comfortable with managing data structures and developing algorithms for complex data manipulation. - Intermediate skill level is preferable as you should have a solid understanding of backend development principles without being overqualified. In your application, please detail your background and experience working on similar projects. This involves explaining your past work and presenting any particular challenges you had to overcome. Each accomplishment ...
I'm looking for a skilled Laravel developer to help me with maintenance tasks and add new features to my current project. I am seeking a senior-level Laravel developer to construct new modules, update existing code, and address bugs on a regular basis. The developer must be available and promptly address feedback. Key Tasks: - Update existing code to ensure the project runs smoothly - Address any bugs that may exist in the code What's Needed: - Solid experience in Laravel development - The ability to identify and fix issues in a timely manner Ideal Skills: - Strong knowledge of PHP and Laravel - Experience with database optimization - Familiarity with debugging and finding and addressing bugs Skills Required: PHP Laravel HTML API Integration JavaScript We'll a...
...medical concepts into Turkish for my pain management clinic's website. Key Requirements: - Specialization: The copywriter should have extensive experience in medical copywriting, preferably in the area of joint pain management. - Patient Testimonials: The website should include real patient testimonials, so the copywriter should be skilled in incorporating these into the overall content. - Language Level: The content should be highly technical to cater to medical professionals, ensuring a precise and accurate representation of our clinic and services. Your role will be crucial in helping us connect with our Turkish-speaking audience. A deep understanding of pain management and medical terminology is essential, as is the ability to deliver engaging and authentic patient st...
Hi there, We are a travel agency looking for an expert in API integration to answer the following questions: Is it possible to connect and our own booking system to check and update automatically accommodation availability, rating, pricing and meals within our internal booking system? It should take into consideration a radius of 5-10km from a certain city point. Our own booking engine works automatically as follows, it sends a booking request to the accommodations on a certain accommodation list (from the first to the last one on that list) following a rule: if the first accommodation on the list denies our booking request, automatically the request will be sent to the second on the list, and so on. What will the requirements?
We have a project which needs an expert who is experienced with either Haraka or Postal. The project requires understanding, building and managing SMTP infrastructure on a deep technical/engineering level. To simplify the project it revolves around receiving email, modifying some of the headers and then sending it on for delivery. We expect there to be some development involved to achieve the final desired outcome. The full details will be explained in further discussions. We will need the installation and testing of the solution and ongoing support and consulting after implementation. Please note, we are specifically looking for a technical expert in handling Haraka/Postal/SMTP. This is NOT a project focused on email delivery as it is applied to marketing type emails and reputat...
We are looking for a computer program that can take over some of the repetitive tasks we currently do manually. The program will primarily be used on Windows OS and should be capable of performing the following functions: - Automating data entry tasks - Organizing files efficiently - Managing emails effectively - Checking invoices to prevent double billing Ideal candidates for this project should have: - Experience in developing Windows-based automation software - A strong understanding of data entry, file organization, email management, and invoice checking processes - Proficiency in designing user-friendly interfaces - Ability to integrate error prevention mechanisms to ensure accuracy Your solution should help us streamline our work processes, reduce human...
I need a specialist in server maintenance and troubleshooting, particularly for my Dedicated Linux Server Level 2 Strato. The key tasks required are: - Recovery: I need help with server recovery, the ability to troubleshoot and restore the server in case of failure. - Update: Keeping the server software up-to-date is crucial for security and compatibility. I need a specialist to handle the server updates effectively. Ideal skills for this job include: - Strong expertise in Linux server administration and management. - Proven experience with server recovery procedures. - Proficiency in updating server software without causing disruptions. - Strato dedicated server recovery - Operating system Ubuntu 16.04 LTS 64bit + Plesk Onyx (unsupported) - Ubuntu is outdated therefore weI cant ...
...europrofiles, specifically IPE and HEA sections, to produce a structurally sound and efficient design. - Deliver a fully detailed design, including connections and fabrications, and provide 3D models and a Bill of Materials (BOM). I plan to utilize the design for both construction and permit approval, so it's crucial that you're able to create a design that meets both these needs. This requires a high level of precision and attention to detail. Ideal skills and experience for this job: - Proficiency in Autodesk Advance Steel software. - Extensive experience with europrofiles, particularly IPE and HEA sections. - Proven track record of delivering fully detailed designs with 3D modeling and BOM. - Past experience in industrial warehouse design is a plus, but not a nece...
My business, , is in need of a talented SEO expert to h...elements, site speed, mobile optimization, and overall website health. Primary Content: - Our website primarily features content related to marketing services. This will help you better understand the tone and nature of the business, and how it appeals to potential clients. Skills and Experience: - Proven track record of successful SEO campaigns, specifically in attracting clients on a regional level. - Proficiency in technical SEO techniques and tools, with experience improving website performance. - Understanding of marketing services and the ability to utilize this knowledge in optimizing the site for client attraction. - Good communication skills and a collaborative attitude to work alongside our team.
I'm in need of someone to help me add 500 products and more to my WordPress website. All product information (including title, description, price, etc.) and images need to be copied from other Website Key Requirements: - Adding 500 products to a WordPress w...500 products to a WordPress website - Experience with products categorization and tagging Additional Details: - The products need to be both categorized and tagged efficiently on the website. - You would be required to ensure that each product is accurately represented with the appropriate information and images. Ideal Skills: - Proficiency in WordPress - Experience in product listings and data entry - Excellent organizational and categorization skills - Attention to detail to ensure all products are tagged and...